Zelda on the Super Nintendo will never be matched in epicness.
A Link to the Past is one of my all-time favorite games ever.
The Ocarina of Time is easily tied, I cannot sit there and choose one or the other.
Right behind, chasing those two and nipping at their heels, vying to be seen in the same light, is Twilight Princess (for the Wii, motion controls brilliant in execution for such a game imho).
That game took the elements of those games that worked so well, and added its own little flair. The reason I cannot yet determine how it truly stands in comparison, is because I have yet to hook the Wii back up and continue playing that game. I am not really all that far into TP, but it just feels so damn good as a Zelda game. It seems to be a game people either love or hate in comparison to other Zelda games.
The style of play and the incorporation of the dark world is just awesome. Reminds me a lot of the dark world in A Link to the Past, like how you turned into a bunny whenever you went into it at the beginning.