i don't get what you want from a text tone. like, i would be irked if we couldn't do ringtones, but text tones i don't really care about. like it should be short and to the point.
I'm a sound designer, so I have heaps of original and awesome little sounds to chuck on my iPhone to make it sound cool. I designed my ringtone and I have a bunch of text message tones I designed for old Nokias. I even did up some cool 80's game tones which make rad text message tones.
... apple achieves that. most of the time, people don't even know what it was that rang.
In my social circles and with work, I can pretty safely say if Tri-tone sounded off when I got a text message, 90% of people would know exactly what phone was in my pocket.