Technology Connections has recently published an in-depth piece of the advantages and disadvantages of in-room heat-pump water heaters [1].
The tl;dw is that it is significantly slower than a resistive or gas-powered water heater, and lowers the temperature of the room by a few degrees, but nothing major. You have to over-provision them compared to your needs. And they are way bigger.
> significantly slower than a resistive or gas-powered water heater
This was TC being a weirdo. He bought a 120V hot water heater. Had he done a regular 240V water heater the recovery time would be comparable to pure resistive water heaters.
But the takeaway about cooling is important. These things barely chill the room they are in.