I do not agree about Duke Nukem Forever, my father who is a huge Duke 3D fan, played through it and enjoyed it immensely, but it was sometimes difficult for him. I have played the first level, it was great fun. I still intend to finish it when I got time. It's just as if journalists are joint together to sink DNF by making it a synonym of a bad game, which it isn't. Also I dislike the "Leisure Suit Larry never was a great franchise" remark. Says who? Neither fans nor critics nor sales ratings nor recent kickstarter campaign results would agree to that.
If you want ruined expectations, take Assassin's Creed 3 - I played through the first three games with pleasure, but AC3 I just threw away, the stealth mechanics are buggy, dialogs are dull, face skin is shiny like polished boots, the story is full of clichés and forests where all animals from Noa's ship hop about in hordes just for your hunting pleasure are the last nail in the coffin. Got the bug where I can't click anything during some vital assassin operation - purchase of wood for trading or whatever galactic reason, and decided it's quite enough. That's your number one, when I read that it's based in USA during civil war, I thought it's April's fools day.
And what about Force Unleashed? I'm sure many fans will agree to me that the initial hype was tremendous with that starship stopped with one move of a hand and all the concept art shown, people were expecting magic. But then there were these videos where some ugly bloke yapped and yapped about how great things are and will be, and the more he talked, the less I believed in it - when I saw the gameplay, I thought it's a handheld console game. I didn't even buy it, not even downloaded a pirated version for free, it was such a disappointment after expecting a new Jedi Knight style game.
Also Doom 3 was a disappointment for me. It was over-hyped with all the press coverage and videos, but it turned out to be a pre-programmed roller-coaster ride with skeletons popping out from the walls at certain times. I got stuck somewhere on a train with a flash light, and got so bored, I quit. Not at all a sequel to Doom 2. Great engine, terrible game. Same with Rage, I suppose.