There's still room for improvement, but Linux gaming has come a long way in a short time.
I remember when Proton launched it was like magic playing games like Doom and Nier Automata straight from the Linux Steam client with excellent performance. I do not miss the days of having the Windows version of Steam installed separately.
Linux Mint is often touted as the most similar looking GUI to windows, so if you want Linux, but looking like windows that might be your best bet. You will find many guides for how to install Linux. If you want to just try it out first (and not just overwrite windows), you'll need to free up some disk space and create an empty partition to install Linux on.
Linux mint is just nice to deal with. I distro-hopped to see what was out there but I came back to mint. It plays my games and runs my AI and works with whatever old garbage i plug in without needing to download shifty drivers from a shifty site like with windows.
Honestly, your question will get a ton of different answers because it's so open to people's preferences. It's like asking "I want to start using a car, which one should I buy?" There will be so many different answers that it's practically useless, from people recommending a toyota aygo since it's cheap, easy and reliable to people recommending a Abrams tank "because it can handle everything".
imo, try Linux Mint or Ubuntu since they are accessable and bring most software out of the box. But it's up to you, you cannot really lose when picking a distro.
If I had to guess OP is probably talking about DLSS 3+ which is not supported on Linux at the moment. And what other reason is there to buy an Nvidia 30 or 40 series card if not for that?
As noob, who is not interested in learning the core of linux, but only want it to just work, I would recommend the new openSuse slowroll (based on own experience with tumbleweed which should in theory be less stable than slowroll) and for apps I recommend going for flathubs.
I’m not sure if slowroll already released.
If you go down this route, even as a noob, whatever tech issues you may run into, it will likely be easier to find command line interface [CLI] solutions that you can copy and paste into your terminal aka console.
I know it seems extra and harder because it looks like something a hacker would do. But telling someone where to click a mouse over and over again is so much harder than "copy this into a terminal app, and send back the output"
As a fellow older gamer who is also technical, I'm using Fedora with KDE, and I install the Steam client and the Bottles app for non-Steam games.
If you're not technical, then I would suggest something like Linux Mint or Ubuntu, but KDE gives you the closest experience to a Windows desktop regardless of which version of Linux you're using (vs Gnome).
But as others have said, it doesn't really matter (for the most part) which version of Linux you use, it really comes down to using Steam and Bottles for the game support.