Many people in rural New England have or wish they had secondary power generation because you need that local energy more often when there are external events that likely also break the grid (big snow storm).
The chain of events is "once in a gazillion century storm wipes power to huge region; millions of households are stuck without power, power company can't go out and fix all the broken things for weeks/months, many people have their houses wrecked by frozen pipes / die from running poorly improvised heat systems"
The round trip energy storage with batteries is pretty good but not terribly cheap at scale. The round trip into hydrogen, theoretically, seems pretty good but the actual "nuance" in the equation is basically a bunch of dragons waiting to eat you and everyone who ever loved you. Anyone selling a "power into hydrogen" thing is probably actually selling a "turn natural gas into hydrogen and sell that hydrogen to hippies" thing.
Maybe if you can figure out how to stick a carbon or two or three onto those hydrogens you'd be in business, but it's hard to get those carbons.
Anyhow, this is a hard problem. People have gotten used to hydrocarbons which are basically magic given their stability and energy density.