There's several debates going on, and I'll try to state my opinion on all of them.

Halo: A tad over-rated, but deserving of A LOT of the praise t hat it recieves. Its about time AI had a brain when it comes to FPS. And the opening rocked. My big problem is, people are taking it too far (as with counterstrike). You can get booted for not being good. Does anyone else see a problem with that? I also think that half life is worthy of every bit of praise. The action is tight, and the story is superb.

Metal Gear Solid: Not over-rated. Its been around much longer than other stealth games, Splinter Cell owes MGS a lot.

FF6: I really don't know how good the graphics are, considering I'm not rooted in an SNES, I don't generally compare graphics between them. Good music. Overall, mildly over-rated (not as bad as 7 though).

For the next few, you need to understand where I go to school. I go to an alternate school, where your either a gangster, or you smoke pot everyday, or both.
I'm sick of hearing about:
GTA 3: The game is just boring. "Hey, lets make a game that lacks any sort of plot/objective, while making its sole appeal the ability to shoot cops."
Scarface: "OMFG DRUGS! THIS GAME IS THE (note singular)!"
Madden/NBA 2K7/Sports: "I could school you in (insert popular sports game)! Don't start with me bitch!"

Of course you can school some one in madden, it takes absolutely no talent to do so! The above 3 games are the definition of over-rated.

Ocarina of Time is over-rated. Sure, it did a lot right. But its not TEH BEST EVAR!