I like leighdhu's suggestions, especially Bridge Over Troubled Water. Abide with Me is a nice one too.

I look at it differently for my own funeral though. I want a song that goes with my sense of humor at mine. I'd rather make people laugh and think of me fondly the way I was than cry. Current favorite is Ring of Fire for a cremation.