I use mymyxer.com and zedge.com. Both are pretty good and both are free.
Posted from my CrackBerry at wapforums.crackberry.com
Agree with Wortez.....I use www.zedge.net you have to register, but it is free and they have thousands of tones that work really well.
Also, I have made a couple of my own with the voice recorder on my Curve, using my own voice. I made one that is for when my husband calls me, saying, "it's your gorgeous husband calling, pick up the phone"
I use FunMo.com to make ringtones. You can record anything and can add sound like a robot, rockstar, chipmunk or tons of other crazy voices. You can also mix your voice with crazy background sounds. Make it your own with YouTones. This is cool site.