I don't think I have had a totally shocked moment that wasn't meant to shock me in the game. But something I always remember being surprised at is in Ocarina of Time when you roll or slash your sword for the first time as an adult I was going "Whoa! He hit puberty! His voice got deep man!"