There is no way to turn the status light on or off with an automation. It turns from blue to red when an event happens. You can also turn on the spotlight (on cams that have it) when motion is detected, and play a sound, but only the pre-loaded sounds, not a custom one.