AS a funeral piper, I must recommend Highland Cathedral. Not only is it incredibly moving and beautiful, but when you have a church organ play with a piper, there won't be a dry eye in the place.

Here's an mp3 so you can understand what I'm talking about:
http://kilby.sac.on.ca/ActivitiesClu...0Cathedral.mp3

This was recorded by the 142nd St. Andrew's College Highland Cadet Corps with St. Paul's Organ.