My floodlight (unknown brand)
had this system. Sounds like it meets your needs. The manual mode over-rides the motion sensor and day/night sensor. Be advised, though; the slightest mains glitch or brownout gets interpreted as a double-pulse and causes the light to lock on indefinitely (and run up your utility bill), requiring the mains switch to be operated manually to switch the light off. I got fed up having to do this, so the light has now been removed
.