Many years ago, when I was in the same boat with Ocarina of Time as we all are now with Twilight Princess, I read up on an interview with Shigeru Miyamoto, who claimed that
OoT would have many "horror elements", that would be in comparison with the Resident Evil series.
Obviously, an exaggerated point. However, this aspect of Zelda games may be most apparent in Twilight Princess.
Personally, I'm not a fan of the horror genre, be it in video games or movies. But I make the odd exception. F.E.A.R. was a bland and mediocre shooter at best, it's horror was subtle at first but quickly became predictable. Half Life 2 had Ravenholm, and that was a perfect experience for me.
~ Adhamh.