Yes it's a great game, yes it's well worth your money and time, but no, it is not the greatest game of all time.
This game really doesnt give me that feeling that i am playing an amazing game that will make me remember for a long time. The dungeons can get really annoying with their puzzles and brain teasers. In fact lately I realized that Zelda is practically puzzles. And I don't like the fact that you always start at Link's house. It can get a little annoying having to go across Hyrule field all the freakin' time. Some kind of teleporting would be nice.
But the gameplay is actually very well done. You can go to the town and talk to people, figure out little secrets, and play fun games where you win stuff. And the graphics are smooth and flawless and really just were spectacular for its time. The sound is good I didn't have a huge problem with that.
So, is this game a bad game? No! That is not at all what i am saying, any gamer can enjoy this game. The point i am trying to broaden to truth, is that it is NOT the best game ever made, there are way to many fanboys that exaggerate this game. But any N64 owner who does not have this game, should get right away while there are some still left.