The hero's journey refined in videogame form, this was a benchmark for the industry on release and still holds up to this day.
While not as perfect as many believe, the game captures the spirit of adventure the Zelda series strives to go for, while presenting a story that can seem bare on the surface compared to modern day game, is ripe with subtext and themes for the player to make out.
Do not expect the perfect game, but expect a damn good one that will leave the player satisfied right to the end.