In my experience, interesting ringtones are mostly just used for alarms & reminders. A classic being Chop Suey by System of a Down as your wake up alarm.