A family of 4 is normally fine with a 60 gallon water heater. Doubling that to 120 gallons takes up roughly 1 extra square foot of floor space assuming a 6’ tall tank. If you’re living in Manhattan at ~1,500$/sf might be worth it to avoid peak rates, but just about anywhere else it clearly is.