I assume that you currently have a standard mechanical wall switch which you just leave in the on position, allowing your automations to control the lighting?
That being the case, you could consider the Sonoff ZBMINIR2: ZHA: Advanced features of Sonoff ZBMINIR2.
This sits behind your existing wall switch and, with its decoupled mode, allows you to continue using the mechanical wall switch to turn the light on and off (note that this does not cut power to the Hue light). Your motion automation could contain a condition to check the state of the relay and if on not fire the motion timer to turn the light off. You then flick the switch on your way out of the room.