Very common. Almost all of them at HD work that way. I think you have to flip the switch twice to get them to stay on.
Exactly.
Just about every motion sensing outdoor light fixture or separate sensor piece that you can add to any light to make it motion sensing, works as the OP wants.
Once installed, if you turn the light switch that controls the light fixture to the "OFF" position, then wait about 12 to 20 seconds, and then turn the light switch to the "ON" position and leave it on, the light fixture will be in motion sensing mode. This means the light will come on when motion is detected, and then shut off at the set amount of minutes you choose on the bottom of the sensor. Also, the light will not go on during the daytime because most of the motion sensors also have daylight sensors to keep the lights from coming on during the day.
If you turn the light switch that controls the fixture to the "OFF" position, and leave it there, then of course the light fixture will be off indefinitely.
If you turn the light switch that controls the fixture to the "OFF" position, and then immediately to the "ON" position, the light fixture will stay on indefinitely, even in the daytime, until you either turn it off or reset the motion sensor.
To reset the motion sensor, you flip the light switch controlling the light fixture to the "OFF" position, then you wait approximately 12 to 20 seconds and then flip the light switch up to the "ON" position and leave it there. This will reset the motion sensing ability of the light fixture so it comes on with motion and off at the pre-determined time, as well as not come on during the daytime.
Hope this helps.
Jim