There is an app called "Missed Call", which will allow you to choose which color LED you'd like, for which missed event.
So, you can have blue led for missed calls, cyan for missed SMS, yellow for email, etc.
On my myTouch and Droid, you had the following LED colors to choose from:
Blue
Red...