It is not my ringtone, but one of the weirdest ringtones I've ever heard was from a plumbers mobile phone who did maintenance work in a hotel where I stayed for some nights. He used the famous music clip from the "Shower Scene" from Alfred Hitchcocks "Psycho"; that one with the screeching violins. This ringtone makes quite sure that one definitely doesn't miss a phone call