I'm looking at you NiGHTS 2.
What sequel did you look forward to for years (and years) hoping, praying that it would finally get released and when it did...it sucked?
Duke Nukem was another that I was hoping would be awesome, even if it was just running around and shooting stuff with cool weapons and horribly funny one liners and all I got was a metric trout ton of forty minute load times.