The sound I get when receiving a new text message is the camel from that Geico commercial yelling "Hump Day!" Sure, I could find a less obnoxious notification sound, but it makes me laugh every time, and that's important.
However, it may not make my friends or coworkers laugh, and is probably downright annoying to everyone when it goes off in class or a movie theater.
To avoid those awkward situations, I now use Persist (Volume Control) by Netroken. This app (free on Google Play) lets me create preset volume settings and control all of my Samsung Galaxy S3's different sounds from one place... more