As usual from Microsoft, the answer to the Visual Studio issue is, "Fuck you." Not a surprise, but I'm grateful for the Dolphin devs working through all this.
It's not a "fuck you". What the Dolphin devs want/expect is simply mutually exclusive with how app dev on Windows works. This is a case of Chesterton's Fence, as those decisions have obvious reasons if you think about them outside of the narrow-minded constraints of an open-source emulator project.
I mean I ship commercial non-game software on Windows, and the easy solution is just static linkage. Microsoft's preferred solution is that everyone should have an enormous installer which includes their entire redistributable. It's not great.