For single player, the majority of games should work just fine. Most gaming issues nowadays are either because of invase DRM or anticheat, but more and more games are getting support. A large part of it is thanks to the steam deck.