I know that Danny Boy is overplayed but I heard a man sing it in church once and my eyes just unloaded!
I once knew a priest who would sing it during mass for Irish American funerals. Beautiful voice, very nice fellow, and he was a great friend of the pipes.