Not trying to be elitist, but this is where I think console games have a bit of an advantage over PC. There are NO games made for consoles that cannot run on consoles, although the obvious trade off for reliable performance is graphical performance.
Anyway, on topic. I don't play the games I bought on steam very often, so kinda my entire library is techincally dead. That said, I played them when I got them. I purchased a hard copy of Red Faction Guerrilla however, and even on the lowest settings, I still got an appalling framerate, but I stuck it out to the end, because I actually did enjoy the game barring that.
I also aquired a copy of Crysis 2 on PC, but I could only play through about a quarter of the game because the framerate was running at 13fps on lowest settings...