I would say getting 2000 points in the archery in Ocarina of Time. I try and complete everything as much as possible and I finally got it after about 3 hours or so. This was for the N64 version. I'm not going to try and get it on the 3DS version.
Stepping into the water temple for the very first time in OoT.