I havn't been able to find anything that does this so far. But how great would it be to have an app/mod/etc that allowed us to just point to a directory full of sms sounds so that we had random SMS sounds. And another directory for ring tones etc.

There are a lot of ringtones and sms sounds that are really cool but get old really fast.