I found it epic when Link had the dream when Hyrule Castle was attacked, and Zelda was riding out of it with Impa, as well as when the Deku Tree first mentioned the actual legend of the Triforce (with Ganondorf riding his horse through the flames along with the three goddesses: Din, Nayru, and Farore), and then it became even more epic when Link pulled out the Master Sword from the Pedestal of Time, allowing Ganondorf to get the Triforce from the Sacred Realm to make himself the "King of Evil". It got better and better from that point on.
This is a game that I will never stop playing like all other Zelda games. Ocarina of Time, with no doubt at all, is my #1 favorite Zelda games out of the series of all time. I'm so glad Nintendo is remaking it in 3D for the new Nintendo 3DS.