Marines Hymn and Taps always make my soul stir when I hear them on the pipes.

For fun I really like this bit of filk called "March of the Cambreadth" by Heather Alexander. Its featured in several books I like, and the theme is awesome.
http://www.mp3dimension.com/HeatherA...hOfCambreadth/

Really though anything on the pipes is worth listening to.