There's only been a few that I've owned in my lifetime that were terrible or not worth the money in retrospect.
Sim Earth (NES) is the earliest I can remember.
Captain America and the Avengers (NES).
Turok 2: Seeds of Evil (N64) - Varitel nailed the reasons nicely above. Also it sacrificed frame rate for graphics which is a terrible idea for any FPS game.
Grand Theft Auto 4 (PS3).
Sim Earth (NES) is the earliest I can remember.
Captain America and the Avengers (NES).
Turok 2: Seeds of Evil (N64) - Varitel nailed the reasons nicely above. Also it sacrificed frame rate for graphics which is a terrible idea for any FPS game.
Grand Theft Auto 4 (PS3).