Many (if not most) games are playable.

In addition to what others have said here, I strongly recommend compiling your own build of Yuzu from github, which often contains additional compatibility patches that haven’t yet made it to mainline (and for which there is no precompiled binary unless you’re willing to fork over some cash). The instructions are straightforward and should work on any modern distribution.

That compatibility list isn’t worth checking. It hasn’t been updated in years when compatibility can improve dramatically even between minor releases. I’m playing games at 1080p with no glitches on titles that the compatibility list tell me shouldn’t be able to get past the menu.

Also, that list doesn’t consider workarounds making a title playable, so titles like Diablo II, which apparently works just fine if you use an offline patch (haven’t tried this, myself), are listed as incompatible.

tl;dr: If that list says that a game is playable, it’s probably playable, but if it says the game is bad or not working at all, you’ll need to look into it yourself.