Fable 3 is the one that instantly comes to mind. It's like they researched every little thing people loved about the first two games, then went through and made absolutely sure none of it got into the third one. They even made sure to remove all the humorous little item descriptions. Early on, you have to make a bunch of promises to various groups of people in exchange for their help overthrowing the evil king. Once you do, you realize in a fucking stupid plot revelation that the king was being a stingy asshole to save up money to defeat an incoming enemy threat. Why not just warn the citizens and have them help out? Who knows? Once that's revealed, it tries to drop that burden onto you, to make tough choices. Do you keep your promises but then have no money to stop the evil? Or do you become an evil tyrant but save the kingdom and hope the people understand later and forgive you?
Well, if you've been dicking around buying up properties and collecting rent since early on (and this is Fable, of course you have) then you've already amassed such a huge amount of money as to completely render an entire section of the game in which you're forced to follow through and either keep or break your promises, directly impacting the fate of your kingdom and subjects, which is meant to be emotional and heartwrenching, absolutely pointless. The game constantly tries to add weight and consequence to everything, and fails hard every time. The whole "keep playing after you've won and become king" angle was completely wasted. There's a reason no other games did that, and it's probably because they knew it would turn out like Fable 3.
Fable Anniversary is awesome though. At least that let the franchise die on a high note, instead of just fading away after 3 and Fable Journey shit everything up.