"On a side note, the thing I like about OOT's dungeons is that I actually don't enjoy playing through them that much. As kid, I dreaded going into a dungeon, just like Link would. And, conversely, I loved riding on a horse and going fishing, just like Link would. This is in contrast to most games, where the fun part is the stuff that would be horrible in real life. "
This is brilliant.  BRAVO.  I always felt the same about Zelda.  The original Dungeons of the first game, and OoT made me nervous, excited, and frightened.  I knew I was entering something challenging, will face new enemies, puzzles and surprises, and I dreaded it as much as I loved it.  
It was brilliant design.