Personally, I'd say some of the freakier things in Zelda are the bottom of the well, ReDeads, Dead Hand, Wallmasters, The Mummy Father in Majora's Mask, the final day in Clocktown, Zant, Puppet Zelda, and the Majora boss fight.
What do you guys think?