Lightflow (somewhat mis-named) let's you change both the sound & led color. Note that it doesn't work with gmail since a few updates back, google blocked 3rd party apps from access to it. The sound can still be changed from within the gmail app, but the led cannot.
Sent from my DROID BIONIC using Tapatalk
I am not sure if this is what the original poster wanted or not but I am looking for something that will allow me to have different sounds for different contacts.