Just had one recently.
Hydrophobia: Prophecy. Looked really nice on video and gameplay but apparently its lags like hell. So much you can't even play the game.
Well, that's just a recent example. Played many bad games, too much too name em all ;p