As far as Piobaireachd, my favorite is "Lament for my Brother", which is the only I've heard live. Played amazingly at a funeral, it was probably the most powerful tune I've heard. The second most would have to be Highland Cathedral played with a church organ. The organ and the bagpipes go together very well, but make sure they're tuned!