Linux works great for gaming in my experience. I have a huge games library and I haven’t had many if any games that don’t run. There are certainly some games that need some tweaking to get working or optimisation to run well. I generally have those problems with older games though as my library includes some retro games (games for Windows 98 being the ones I have to tweak most).

Mods certainly do work - I’ve modded skyrim and rimworld extensively on Linux, as well as Oblivion, Cyberpunk 2077, Stardew Valley, Cities Skylines, Minecraft and more without issue. Proprietary mod managers may not work but they’re often the poorer ones that are really just tools to advertise and market at you.

The vast majority of game mods work inside the game itself, so if the game runs on Linux the mods will work. The exception would be mods that need to run as a Windows program themselves separate to the game exe. Those can also be made to work, it’s just a bit more involved. Those kinds of mods are pretty rare in my experience though. Mods that act as game launchers etc work fine too, but just need some tweaking to ensure they launch instead of the game exe.

Most games mods can be manually installed and big games even have their own Linux native mod managers - like Minecraft custom launchers and Rimpy for Rimworld etc.

I do still have Windows on my PC in case I need it but haven’t used it for gaming in well over a year. I have a desktop so having a spare drive for windows is not a big deal to me but I’m tempted to wipe it as I don’t use it.

The one bit that people do have issues with is Anti cheat software for multiplayer games. That’s not an area of gaming I do, but I have seen reports of certain games using proprietary systems that lock out Linux. That’s a problem you can’t get round except by having Windows available on your system.If there is a specific game you want like that isn’t working on Linux.