There is a 3rd party application that I reviewed a while ago. It IS one that you have to buy. However, the features allow you to change your light color based on certain settings. I will see if I can dig up a link. This however, does not change your light based on SMS or email.
** ah here it is...
BlinkBerry for Blackberry ***
Gecko