Games that require certain anti-cheats that either valve doesn't support or the dev doesn't opt into. It seems to be mostly related to multi player online games.

Also games that have issues with patented codecs, although valve is working around that by transcoding them to a different format, so they can play locally without the relevant decodre