This is a tough question. I really don't think I have an answer.
I can't say Ocarina of Time, because to me that is still the greatest game ever made, so no amount of hype will ever be "too much".
I can't say Skyward Sword, because that game doesn't get more praise than it deserves. I haven't met very many people that consider it the best Zelda game, and most people I talk to actually think it sucks. Which it does.
I can't say Wind Waker, because that game got incredible amounts of hate when it released, with what the visual art-style and "kiddie" presentation. Eventually people saw it for what it was, but it was never overhyped.
I guess I would say Twilight Princess. Though I'm not sure even that's right. Not a lot of people were ranting and raving about it. Although it did make people cry real tears when it was shown in E3. I guess that's what's pushing my vote for Twilight. The fact that people cried when it was announced, and it ended up being just an above average game.