I personally adore the Song of Storms, the Bolero of Fire and the Song of Time.
I love the rhythm of the Song of Storms and the Bolero of Fire, the Song of Storms is generally quite a fun tune anyway, I whistle it before it starts pouring it down.
The Song of Time makes me feel really emotional, I almost teared up in Twilight Princess when I reached the Temple of Time...