I wanted to use one of my own ringtones for texts too, but even in Froyo I could never figure out how to do that, let alone Gingerbread. It would be nice to do the same for the alarm clock.
Download the Ringdroid app. That will convert ringtones sent to your phone so that you can use them.