This is going to sound stupid....
"The Bolero of Fire" from Ocarina of Time was my favorite. I would find myself just teleporting back and forth from Lake Hylia to the cavern just to hear the song.
God that's pathetic
I also like the Song of Time (The one that moved those blue blocks
)