I went to Settings > Sounds > Notifications
The only option under Notifications is Notifications Ringtones. It does not have an option to set texts as one tone, emails with another, etc.
I've had other phones where I could do all this individually. I had a tone for incoming calls, a tone for private/blocked calls, a tone for texts, a tone for voicemail, etc.
I just can't seem to figure out how to do this, if possible, on the Droid 2.