Great question @BigFan . The Smart Lighting Floodlight will flash twice when power cycled and then will revert to whatever the settings were before power cycle. The default is for the motion sensor and light sensor to be on so the unit would not light up after these two flashes unless it was dark and sensing motion.
The Floodlight Camera is, of course, different in that it will activate lights following a power cycle and would have to be turned off manually in the app afterwards.