This type of thing would really need to be implemented at the township / local community level at least, similarly to how every house doesn’t have a big electrical substation plugged into the high-voltage power mains with explosive oil-cooled transformers. It’s simply not realistic to think every private dwelling can or should have this kind of capability, to say nothing of the cost. Maybe large communal housing could. Ultimately it’s a sort of social optimization problem and I don’t think giant individual capacity solves it efficiently.

One thing that could possibly work better IMO is something like a small local renewable fuel economy where excess power is used to produce hydrocarbon fuel by catalysis of electrolyzed hydrogen with carbon sources, and individuals can purchase this fuel to recover the energy, or possibly the power plant could use it during solar lows.

The advantage of this type of system is that it’s not really capacity limited, as long as you have enough fuel storage, which is simple to build more of.

of course, you could just use alcohols distilled from fermented plants instead, but that’s not as sexy.

>This type of thing would really need to be implemented at the township / local community level at least,

Even better - both. Increase the independence and redundancy in several steps, making the grid more reliable and less prone to failure from single events.

>It’s simply not realistic to think every private dwelling can or should have this kind of capability,

Why not? You can get 10 kwh of storage for the price of a phone and laptop. Any EV has more battery than what's needed to power a home for days, some of them already have the capability to do so when combined with the right charging station.

Of course not everyone will have it, but surely battery storage could become as common as air conditioning or central heating even at current prices.

Why liquid fuels or chemistry at all? Something simple like moving blocks of cement uphill with a motor/generator would be more efficient.