Probably the quickest I've ever lost interest in a game. After the short starting dungeon, it didn't feel like I did anything for several hours. The large Hyrule Field becomes just a vast expanse of time-consuming nothingness as you can just run by any potential threat (or just stay on the path and have zero threats). Other than hunting for Golden Skulltulas (btw, was Nintendo just completely incapable of coming up with a useful reward for completing their collect-a-thons?), nighttime is virtually pointless, not to mention that it is ridiculously short (if it's 2 minutes, I'd be shocked) in areas where time passes. The amount of time spent between the handful of dungeons made finding the will to finish this game difficult.
This game is a good demonstration of the shortfalls of the N64 controller:
You can't change your camera angle on the fly due to only having one analog stick and no useful "left" option if they were to give the right shoulder button a camera rotation function.
As with the vast majority of N64 games, the left 3rd of the controller is almost literally useless (I can't imagine many people ever actually turned off the field map, which would gain you no advantage).
The inability to voluntarily jump or climb is horrible. I don't like having to rely on the game trying to figure out what I want to do. Plus, you have to be perfectly lined up with a ladder in order to climb it. Being able to jump at will would be a pretty useful ability in the next to final battle.
I don't usually comment on graphics, but the faces of most characters are atrocious. It's like they took a sphere with a nose and just painted on static eyes and mouth. I don't know if they were going for alluring with the Great Fairies, but if they did, boy did they fail. Not to mention the Great Fairies' high pitched "Whoa-ho-ho-ho!!!" when they are summoned, which fits more with an evil sorceress in an anime rather than a helpful fairy.
On the plus side, I enjoyed the music. I especially like the Opening Theme, the Gerudo Valley theme, and the Song of Storms (although very short).