How to find a motion sensing light switch that turns lights on AND off when motion is detected?
Put the sensor in the space you are trying to light, and suddenly this "common need" becomes "not a need at all" which is why you can't find them, since that's how it's done, when done conventionally. 

Either move the switch into the room or get a remote sensor switch and put the sensor in the room.