From what I've seen, a somewhat more ideal scenario would be a flywheel battery station on every street and a chemical battery in every home.

In that scenario, neighborhoods would take a while to fill up their capacity but once those capacities were full they could easily handle brownouts and temporary disruptions without affecting the larger grid.