I have to say I'm in the middle with the Twilight Princess hating. I feel that it was fairly bland and unimaginative for a Zelda game, however I still like it, and consider it to be a great game. Although I find it to be one of the worst Zelda games I've played.
As for a crappy game, I'm going to go with World of Warcraft. I played that game for hours and I still got almost nothing out of it, I just didn't enjoy it as much as most people seem to.
I'm also going to say Final Fantasy VII, due to it being incredibly overrated, and because FFVIII is so much better.