With the nature of Linux gaming, where tools that are either used to make games run better, or bring features tinkerers/power users use to linux (like MangoHud and Goverlay), I think, at least in the near future, the best distros to use for Linux gaming will have to be rolling. I've tried a few Ubuntu derived distros (Mint and Tuxedo OS), and there are still some holes because their repos aren't kept up to date (in the case of Tuxedo OS, the devs for that distro mirror Ubuntu's repositories and do some things their way, so as to tailor the Ubuntu experience to the hardware their company sells, is my understanding), and many of the devs working on these tools for Linux are Arch users. The Debian and Ubuntu ecosystems are overall known for their stability, but it seems that that's whats holding back that whole family of distros, for the most part, from being ideal distributions for gaming on Linux.
Arch is rolling and may be great for people who want to learn everything about how Linux works, but I don't know if it's great for people who may want to try and game on Linux with a system they have that they can't install Windows 11 on.
This leads me to think the OpenSuse family of distros (OpenSuse and Gecko, which is sort of a user friendly wrapper applied to Open Suse), which are known for being rolling and having the software tested by the OpenSuse team before being added to repos, could be the darkhorse distro for people who are curious about gaming on Linux. I think, at least for a while, until things cool down and settle, Ubuntu and it's offshoot distros will move a bit further down than second place.