My notification tone (text message is considered a notification) is the beginning of Earthshine by Haken.
My ringtone is the middle build up section in Measure of A Life by Arch Echo, when the drums come in.
I used to like making my own ringtones easily in Audacity. These are fine for me and I don't have a desire to change them. I also tend to leave my phone on vibrate most of the time and am able to personalize the vibration pattern, so calls are shorter, rhythmic pulses, while texts are a bit longer pulses. I found that setting pretty useful.
I also used to have the ending piano of Milliontown as my notification tone, but it was hard to hear at times and I would barely notice the piano playing.