i think hpwh are better used in warm climate where there is a lot of cooling going on.

"I realize that the HPWH's draw heat from the basement which will be heated by in floor heat but is it significant?"

I have a heat pump hot water heater in my basement here in Maryland. The heat pump has no measurable effect on basement temperature, however it does serve to reduce the basement relative humidity 3-5%.

The walls of your basement serve as a massive heat sink and changing the room temperature of your basement by operating a relatively small "air conditioner" isn't going to happen. (If your hot water heat pump were installed in an upstairs utility closet, the cooling might be an issue.)

In the limiting case of you actually not using any hot water, for example, any heat energy extracted from the basement air mass would be transferred to the heated water sitting in the tank. In the steady state, there would be as much heat being transferred back into the air mass as would be extracted from it.

A heat imbalance is created when you use hot water and the heat is lost from the basement system via the heated water going to the sinks and the cold water entering the tank to replace it.

My family of two saves about $50 per month compared to my old electric hot water heater. Also, there are frequently tax credits or rebates available.