I loved this game. Sadly, I didn't play it when it first came out, so I played the 3DS remake instead. Here's the rest of my review:
The story was great! I loved how it was based on the elements, and each dungeon was different. The fact that you weren't free to explore made me want to continue following the storyline. The dungeons get a bit harder as they go, though.
I am proud to say that I beat Ocarina of Time, even if I was so close to defeat Gannon with no damage taken. If you like adventures, you'll definitely like this game! (I would prefer buying the 3DS version).