Another vote for you to try the free version of Lightflow in the Play Store.
It will change everything about your SMS notifications (and more). YOu will be able to change the ringtone per user, the frequency of the flash, how often it flashes and for how long. Also the LED color depending on your hardware.