Despite the fact that I own a working N64, I'm downloading this game once the Revolution comes out. BEST GAME EVER!
What's there to say? The mark of a truly great single player game is that it never gets old no matter how many times you beat it. Once you beat Ocarina of Time, you'll want to try it again, except this time without any pieces of heart; after you beat it again, you'll want to go through it once more with three hearts throughout the entire game. Then, once you beat that, you'll want to try to go through all the temples as fast as you can. Then, you'll keep playing the final fight with Ganondorf, again and again and AGAIN! That's how good this game is.
And speaking of Ganondorf, your final showdown with him simply stands out as the single most exhilarting moment in videogames in the early 3D era, if not all time. Ganondorf simply puts Sepiroth to shame.
There's really not much to say except if you have never played Ocarina of Time, you have missed out on the most critically acclaimed game of all time.