iPhone 4 Custom SMS Text Tones
There are new SMS tones as of 4.2, and you can assign a specific SMS tone to a specific person via the Contacts app also as of 4.2, but you still cannot create custom SMS tones in the stock firmware.