One of the cool features of some roms is the ability to modify the color and pulse rate of the notification LED. Well with Light Flow you don't have to be on Cyanogen you can change your notification light from any Rom or even from Stock. This App does require Root. The only setback is that it does require text messaging permissions so that it can see when a text is coming in and send the appropriate colored light. They say that they dont have access to the physical text and I believe them. This App has been around for several months now and no one has complained of any privacy issues. This Mod really stands out because it adds instant functionality. You can clearly see what type of notification you have whether it be gmail, mms, sms, gtalk, ect.
More Info and Download link here