The most unusual solution I have ever seen this problem is a manual version of what you suggest.
They had installed a 'doorbell' system. The button was slightly hidden, under the lip of the counter, or some other convent place The 'ding-dong' part was replaced with a low voltage relay connected to the hot water circulation pump.
Before tap was turned on, you the button for a short time. (the kitchen was count to 6)
JimmyFix-it's comment about the thermostat control is the most common by far. His remark about pipe of your choice and vacation switch are both good.
The motion sensor, I like the idea, but it is likely the overkill geek in me. Again jimmy and the false positive thought seems right.
There is the idea of motion sensor that points at a place that you have to think about, a small area under the counter, easy to find, but not easy to use by accident.
I think the easiest idea is the remote thermostat. The next one would be a low voltage button, that started a 30 second timer for the pump.