I don't have a cell phone, and I don't really need one. My friend has a hilarious ring-tone/text message. It's a guy screaming, "PICK UP THE PHONE!!!!" really loud xD. Another is a guy is quietly saying, "Ring ring ring" then gets louder everytime.
I ALWAYS unless there are special circumstances, keep my phone on vibrate. No one wants to hear your obnoxious ringtones, and beeps and songs and such. Its just plain annoying. Especially in public.
Whenever I have the sound on (usually whenever I absolutely have to receive a call and cannot miss it), when there is an incoming call its just a standard old phone ring. When I get a text it does three beeps in quick succession.