For hot water heaters, it's obvious that the water would arrive cold if it were boiled in a central location, but electricity can be transmit so efficiently that storing excess load will be much more efficient in centralized locations rather than at individual houses.
My guess is that this will be roughly as common as household generators, since both this and a generator are hedges against the electric grid failing more than anything else.
The equivalent water analogy would be everyone having their own household water cistern in case the water system failed, which I also think is vanishingly rare.