Sadly, all my high hype experiences have ended terribly.
My top three are probably Halo 3, Gears 2, and Destiny.
Gears 2's online didn't work at all for months after launch and the online portion was the major reason I was hyped in the first place. I was so disappointed. Not only did it literally take 30-40 minutes to get into a match (if at all), once in there the game was often unplayable.
Destiny was just nothing like I expected at all. I thought it was going to have a deep sci-fi story with lots of rewarding exploration in vast varied environments. Story was 2/10, exploration meant nothing, and the environments were lacking in every regard except for the skyboxes. Really, they were used as wide-open lane ways to drive.
Halo 3 met expectations, only issue was that my 360 broke after 3 days of playing.
I don't believe in hype anymore, I've been hurt to many times.