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.