the only song I ever used was Blur's Beetlebum for my alarm a few phones ago.
I had Crazy Train for my mother’s personal ring tone. I was in the mall when she called one day and this woman a rack of clothes over was staring daggers at me when I answered “hi mom”.
I sorta felt guilty after that.
I don't use anything with words. If there's a riff I like in a song, I'll crop it out with an mp3 editor and use that, I've made several I rotate. My calendar alert is the riff from PF's Comfortably Numb
My text alert varies from the Oompa Loompa whistle (most often), a light saber coming on, and I set my ex's to be Chewbacca