Halo 3 didn't come out that long ago...
It was alright. Definitely better than Halo 2 and the multiplayer is still one of the best ever made.
I think some of the worst hype I've seen is for Haze and Lair on PS3. Those two games were touted to have all these features and whatnot and it just ended up making the game look crappy.