Weez, I feel that way about the song On Eagle's Wings. It's a funeral standard around here. When I was little and in Catholic school, we would sing it all the time. When I got older, I realized it was played at every single funeral I ever went to. Except my father's. I prohibited it from my father's funeral.
Personally, I would rather hear pop songs at funerals than the hyms I sing all the time at church (I'm in the choir and a soloist). Depending on the song and if it fits the person, if usually doesn't ruin the song for me.
When a friend of mine passed away a few years back (holy crap, 6 years now), we played I Hope You Dance by Leann Womack and Good Riddance (Time of Your Life) by Green Day. While that song DOES make me think of him and his memorial services, it certainly doesn't ruin the songs for me.
As for music I'd like to hear..... well I won't be hearing it because I'll be dead, but here are some songs that stick out for me:
You Walk with Me ~ from the Full Monty
I'll Be Seeing You ~ Billie Holiday
The Prayer of St Francis (there are two versions of this song. I want the 'good version' that goes "so help me to love when I'd rather be loved, to understand when I'd be understood... to try to do unto as I would be done to -- to comfort the man who suffers alone forgetting that I have needs of my own")
Angels Among Us ~ Alabama
Flying Above the Clouds ~ Amber
New York State of Mind ~ Billy Joel
Don't Stop ~ Fleetwood Mac
And for good measure: I'm So Hood ~ G Unit
"You're every gay man's wet dream!" ~ MA
If in Heaven you don't excel, you can always party down in hell...