I use this site fairly often for those kind of searches: https://www.lorenzostanco.com/lab/steam/

It won't work for everything (for example, I don't think it'll help with "visually stunning"), but it works well for finding games of particular genres, ones with local co-op multiplayer, and so on.