I think only one person in this thread has commented on Majora's Mask so far. That game is by far the most emotional thing I've ever played. Every minute of it pulls at my emotions. If you really get into the game and think about what's going on and just truly immerse yourself in the experience, it's just amazing, and heartbreaking.
I really hope we get another Zelda game that takes after MM's mood, setting, and story type.