You can use iTunes and a little AppleScript to make custom ringtones for Mail.app. I could have it play When Doves Cry everytime I get email from Anil.

• Anil Dash
• Apple
• email
• iTunes
• Mail.app
• music
• OS X
• ringtones