Here is an all-in-one solution that I think meets all of your requirements OOTB, but it can also be customized…
This solution requires the use of the new rule engine, scripted automation, Jython, and the helper libraries. I have incorporated individual room luminance and it looks to be ready to commit.