Fable is fun for the humor. Any game where you can name yourself "Piemaster" and have people acknowledge you with "Respect the lardass, Piemaster" is pretty great in my book. If you go into Fable with no expectations whatsoever, it just might be the greatest series you ever play. If you expect something of it, you'll get a game you love, but know that the potential you had for it ruined some of it for you.
For me:
Metal Gear Solid: First one (On the PSOne) was cool and Snake Eater was cool. Though 2, 4, VR Missions, and Peace Walker aren't that great in my opinion. However the demo for MGS2 was legendary.
Final Fantasy: Now. Let me make this clear. Final Fantasy II through VI are some of the greatest achievements in the RPG genre, but VII, X, XII, and XIII ruin it. Throwing it to an MMO in the boring XI and the fucking awful XIV make it worse. I was not that great, VIII was salvageable, and IX was not my cup of tea. Majority rules! Yeah Tactics was cool and some other stuff was, but that's not including all the goatfuck spinoffs from the DS and the Wii. And let's not forget X-2. That abysmal turd of a game also exists.
Minecraft. I built my castle in about 20-30 hours. Then what?
Pokemon gens III through V.
I don't hate Uncharted 2, in fact I think it's a great game. Not fucking legendary, though.
Honorable mentions: God of War and Gears of War.