MyiTablet points to a YouTube video which shows one user using a custom ringtone on the iPhone.
It appears to be a proof of concept only. Progress on iPhone hacking has progressed, but few end-user tools are presently available to accomplish anything useful at this point.