I can say garuda linux (KDE Dragonized gaming edition) myself if you want to give that a shot. I did swap from windows 11 to that after some testing with other distros it was the one that felt like it just worked out of the box. Unless the game you want to play runs some form of anticheat it will typically work.

I did also get CnC3 working on it through steam/proton. As for how fiddly it is to get games running. If you own them on steam you pretty much just need to go into the properties and flip them over to use whatever the latest proton version is and install as normal. Modding will take a few more steps when it comes to skyrim etc but i havent really tried going into that too heavily myself. Unfortunately the vortex mod manager pretty much explodes if you try to use it on linux so you end up having to install mods manually but there is a mod manager that may do the trick "Mod organizer 2" but I've never used it.