Though I would generally jump on the FFVII band wagon on this one, I feel I need to point out the other overrated FF game. (Holmes beat me to it though) and it would be FFX.
I can't understand why people love this game. It's an interactive movie with linear dungeons that are there for the sole reason for getting you from Cutscene A to Cutscene B. Half it's cast is just poorly written while the other half is just unlikable, and it's story is riddled with pointless plot devices that do nothing more than convulate the plot while adding nothing to it as a whole. I still believe that FFX is Squenix's tech demo for the PS2. It was only made to show what the PS2 was capable of, not to actually create a good game or story.
Also, Youjirou. About a Link to the Past. Yes, you did need to have played it back in the day to truly appreciate it. But your whole post pretty much describes the experience of playing any of the Zelda games.I had a similiar experience recently when I finally got to play Ocarina of Time (Nintendo, why do you insist on making Zelda a platformer when you're not going to give Link a Jump button?), I can see why people love it so much but it has aged badly.