I use CachyOS (Arch) and NixOS and haven't had any problems. Modding on NixOS is a bit more of a headache but it's not a deal breaker. Everything just works. Sure I can't play League or Valorant or EA multiplayer games but not like I was playing those anyways. IF you do enjoy those games then your linux gaming experience isn't going to be great.

As far as distros go? hell you can play on whatever one you want. Like I said I sometimes game on NixOS. I know a guy that even play games on Kali when he's not doing his pen testing stuff.

Even for older games with Emulation it's great. NixOS is my defacto remote emulation machine because it's so painfully easy to set up retroarch on it. Otherwise I have Ubuntu on my private server and I run RomM on it and it has all my roms on there.