The problem is with older games. For instance, the first Bioshock doesn't have sound on Windows 7 and up. You have to play it in XP mode to get the sound working.

Some games don't work at all. That's why GOG.com became so popular actually, because they make sure their games work on newer versions of Windows. Steam, however, doesn't care.