I agree fully with ocarina of time. I had a N64 back in the day, but I never owned OOT because my parents said "it was too expensive"... so I never got that nostalgia factor after playing it years later.

I would say, in regards to really good zelda games, I absolutely loved Link between Worlds. It's mostly the same map as link to the past, but the main gameplay gimmick of sticking yourself on a wall or moving through a crack was really fun for me. I really like feeling that "aha" moment when trying to figure out if an area is inaccessible or if I just need to think about how to get there a bit more, then finally realizing what I needed to do. Super satisfying. YMMV, of course, but it's worth a shot.