rather than list terrible games (superman64, Et, etc) I think a good thing to note is games that just fall short of their potential, or opt to leave out elements that take away from their genre.
For example (equips +2 Flame Shield), in FFX, with no overworld map, the exploration and free roaming elements of RPG's that many people enjoy was completely removed. The game became extremely linear. Not to mention I friggin hate that game.
Another less biased example: In The Conduit for Wii, they don't have LOCAL multiplayer support. Isn't that the point of the Wii? To have friends over? Wasn't their motto "Wii would like to play?". Completely defeats the purpose of a multiplayer focused game to remove the ability to play with friends unless each person owns a copy, and a console.