Check out https://www.protondb.com, to see which games work well on Linux. Games that are platinum should work out of the box, ones that are Gold might need some tinkering. Most games work great, but a lot of multiplayer games aren't supported.
In general gaming on Linux has been a pretty smooth experience lately. Games on Steam usually just work, but IMO running games outside of Steam is pretty hit or miss. They sometimes need following a guide or trying to fix an obscure issue that only like 2 other people have.
The thing about Linux is that you might have some issues outside of gaming. Things you might not expect like Discord not being able to screenshare audio or that one program you need not working on your distro properly. Also you should know games on an NTFS drive don't work well on Linux, so you can't expect your drive full of Windows games to just work if you have them on a 2nd drive. In general I still think you need some patience if you're going to settle on a Linux desktop, it's not entirely a bug free experience yet.