What I took "override" to mean was to be able to shut off the light even if there was motion detected, not to turn the light on even in the absence of motion. I would think the ability to do the latter would be dependent on the fixture.
Its been a while since I bought a motion light also. When I started reading about the motion override ability that's when I wanted to install switches.
They even have wireless motion sensors now. So you can have the light in one place and the sensor in another. You can also control two lights off one sensor if the lights are in line of sight of the sensor. Bad thing is the sensor runs off of two AA batteries.
BTW, I think what JBFan was referring to is the fact that a lot of the newer motion sensor-activated lights give you the ability to override the motion sensor and force the light on by cycling power to it, i.e. turning off then back on (usually within 60 seconds). To revert to auto mode, you power the motion sensor off for greater than 60 seconds and then turn back on. All this is done via the standard single-pole snap switch.
Well, now, there's what's right and what's right and never the twain shall meet.