Hmm, on the Doom3 issue, it's more a case of fans being disappointed by teh game not being a mindless shooter more than anything else, I pretty much loved Doom3 cause for once, I didn't have to rush and slaughter mindlessly, here I could take my time and all.
As for me, the most overhyped game ever is definitly Metal Gear Solid 2, everyone was talking how it'd be awesome, Konami showed missleading trailers (I'll go as far as saying they lied on purpose as to not lower sales, you just have to look at the back of the game's box, you don't even see Raiden), but in the end, the game was pretty much empty story wise, at least it had awesome gameplay.
__________________
System Specs:
OS: Windows 7 Ultimate x64 Edition CPU: Intel Core 2 Duo E8500 @4GHz
Video Card: MSI GeForce 8800 GTX ("Phoenix Downed"
) Motherboard: ASUS Maximus Formula SE
RAM: 4GB OCZ XMS2 PC6400