Current generation heat pumps are probably still worth it but ultra low temp performance would be nice.
I did run across a release on a new generation of a heat-pump hot-water heater, which does seem to have some kind of grid-shifting built in. A. O. Smith's Voltex AL, https://cleantechnica.com/2022/12/21/all-i-want-for-christma...
Not for heat pumps. In a typical configuration (large heat reservoirs combined with under-floor heating in a well-insulated house), temperature-setpoint changes take 12-24 hours to propagate.
So, governing the (in-room) target temperature settings is unreliable/unpredictable. Whereas the in-pump storage temperature is a whole lot more manageable.
The old advice "turn your thermostat down at night" therefore also doesn't apply to most heat pump installations -- in fact, it might be disadvantageous. "Select the average temperature you need and don't touch it" is much better advice. Need localized heat/cold? Use another solution for that...
Saw one heat pump controller discussed which had a curve set for demand vs outside temperature, and the "thermostat" was to set a delta relative to this.
You could raise the max water temp and install a few tanks to get in the ballpark, but that's an assumption that most systems won't have. Also I wouldn't be surprised if "operates down to -20F" includes reduced efficiency/output that already relies on the buffer/storage to compensate for.
Another comment in the article, regarding electricity grid impacts during peak demand periods, is more interesting to me. Currently, there is no mechanism whatsoever for heat pumps to automatically shift their grid draw (or re-delivery) to certain time slots, and/or to coordinate those slots with other units nearby. Both of these would greatly help to balance the grid, but won't be available until standardization gets off the ground and expensive retrofits are done. That's a shame, really...