Of course there are many non-verified games that run fine as well.
For comparison, the Switch has somewhere between 5,000 and 10,000 games.
Source: Wikipedia lists about 5000, Nintendo says “over 5000”, but this website claims 10,880. Part of why the Moby Games website lists more is because it lists multiple versions of a game as separate games (Xenoblade DE is listed 4 times for example).
Yes, but e.g. I played Song of Farca (playable) and there the SD info was all green except for “this game sometimes shows mouse, keyboard or non-Steam Deck controller icons”. In some games, this just means that the menu is somewhat clunky etc. But in this specific game you have to use the mouse (right track pad) the whole time and the UI is incredibly clunky. This was just very frustrating.
Oxygen not included is another example where you need to use the track pad like a mouse the whole time although in this case the game is even verified. Same goes for Stasis: Bone Totem and Mini Motorways, both very hard (for me at least) to play on SD although they are in fact officially verified.
Observation is a game that runs much better than the other examples although it is officially unsupported. (Stories Untold by the same studio doesn’t work at all because of the weird UI.)
You see my frustration? Often you have to deduce from some gameplay footage or by how the game is presented, how well it will work on the SD.