it is possible to design microprocessors which can just utterly stop. https://en.wikipedia.org/wiki/Static_core power consumption doesn't drop to exactly zero, but it can come into competition with the quiescent current of the power supply.