https://www.protondb.com/ if you didn't know about protondb it's really helpful to look for game compatibility. Proton is what lets most windows games run on linux, and is easy to turn on in the steam compatibility settings.

I'm at the point now that I don't even bother checking ProtonDB unless it's a really expensive purchase. Most things work out of the box for me. With some games that have a native Linux client, the Windows version will actually run better for me.

I'm playing the Oblivion remaster and it works great.

I've been using Cachy OS and Marvel Rivals, Deep Rock Galactic, Deep Rock Galactic Survivor, Crusader Kings 3, and UFO 50 have all worked out of the box including multiplayer. Turmoil and Helldivers 2 required a "tweak" which was switching back from Cachy's version of Proton to the default Steam one. (Turmoil had minor graphical glitches and Helldivers 2 wouldn't work on multiplayer until I did that.)

Linux gaming is worlds better than it has been in ages.

From personal experience testing some games before, indie games ran better performance than they do on windows while AAA games ran worse.

That was years ago tho. Apparently steamdeck uses linux and valve has started helping to the contributors working on linux gaming.

Oblivion remaster works out of the box in Linux.

I can't speak for all, but I did PoE 2, witcher 3 and balders gate 3 and after some fiddling they all worked.

Ironically, windows games run better on Linux than Linux games run on Linux. I wouldn't worry about it, Proton (the thing that lets you run Windows games) is extremely good now. Just make sure to enable it in your Steam settings