Check protondb instead of winehq, it's normally accurate and something like 95% of games are playable now
Though no games outside of steam, personally I don't have many games on anything other than steam that I want to play so I don't know how other launchers fare (though heroic is a thing for epic and gog)
Notepad++ I couldn't say because I only really use terminal based stuff now with the aforementioned million shortcuts, but I think kde's built in one (Kate) does exactly what you want
Nvidia drivers aren't that much of a problem anymore, last big issue for me was explicit sync which they fixed a couple months ago (though some distros make it a bit of a pain to install them)
Rdp not an issue unless the machine you're rdping into is using strict AD settings that only allow connections from other AD machines, you should use Remmina imo it's very good
Xbox one controllers should work fine, I don't own one but I've used controllers that present themselves as Xbox one controllers
Only controller that hasn't just worked perfectly straight away is PS5 and that was because of a Bluetooth setting
As for distro, bazzite is probably a pretty good one to look at, it's immutable so there's a limit to the amount you can break it though sometimes it can make more technical things difficult to do
MPV is a frontend by itsself, just set it as your default in your file browser and it'll play video files if you open them
Depending on the game modding can be a challenge. If mod organizer supports it you can usually get it to work fine, anything that supports mods by default will generally be fine and Minecraft is pretty much the exact same modding experience as windows
While you can do a lot on Linux without the terminal now you shouldn't be afraid of it as it can often be the quickest and easiest way to do things. It's one of the big advantages of Linux in general that the terminal experience is so good
I've found vscode generally doesn't open as fast as np++ did