Does anyone have any experience of adding a mains powered security floodlight to a home automation system? Basically while I'm at home and awake I don't particularly need or want it to come on, but between certain hours and when I'm away I want it to always come on if the PIR is triggered.

I don't have any automation infrastructure yet, so I'd be happy looking into a one off solution with a RPi or a commercial product - whatever's cheaper. (For reference, the light I have is a bit like this daylight LED model - different brand, but looks to be a clone).

Thanks in advance