Majora's Mask followed by Wind Waker and then everything else after those two. Those are the only two games in which I find myself delaying to press start because I actually want to listen to the music.
MY LORD WIND WAKER BY FAR. In my opinion that is the best put together and catchy song ever in Zelda (many would disagree with me)
In my list of favorite zelda songs it is number 2 only because file select/fairy fountain is the song i think of when i think of Zelda, and i love how it's been around forever but they can constantly keep coming up with new renditions of it for each game
i'm so sad that zelda skyward sword didn't have an opening theme. it was so bland, there was nothing to get excited about in the title screen. unlike ocarina of time, it makes you relax before an exciting badass adventure!