I’m not either (besides Minecraft and such) so my personal experience with Linux gaming has been pretty good. There’s some jank with needing to pick the right Proton version and adding command line options, but I’m not sure it’s any worse than Windows - I’ve had to reinstall my graphics drivers way too many times. But there’s a large portion of gamers that almost exclusively play the big multiplayer games, and Linux is definitely not ready for that group.
I use Debian on my servers, Arch on my laptop and desktop. Different tools for different jobs. I tried Debian on my laptop a few years ago but it wasn’t a good fit for me - my hardware was too new for the stable kernel, and the Wayland/wlroots stuff was too far behind. As a server though, especially since I’m mostly running Podman containers, stable and slow-updating is great! I use unattended-upgrades and haven’t had a problem yet.
I haven’t spent much time with Fedora but I’d probably like it as a desktop OS - fairly fast updates, and sticks pretty close to upstream without a ton of custom theming for example. I would miss the AUR, but Flatpak covers a lot of what I need, and Distrobox could handle anything else.