UnlimTones is a ringtones downloading app for the iPhone. The app requires an internet connection to function. The app basically has a list of ringtones on its website, and it allows you to download those directly into your ringtones folder in settings. The ringtones are classified into various folders within the app like Top Ringtones, SMS alerts etc. However, there are only a few ringtones listed there. The Sms alerts do not work as even they are downloaded to the ringtones folder in m4r format.
On the whole Unlim Tones is nice but I still think that there should be more ringtones there on the website for downloads.
Search for UnlimTones in Cydia