Some rough numbers I did a month or two ago - Tesla offers a megapack that has 3.9 MWh at a cost of $2.4m. "In 2021, the average annual electricity consumption for a U.S. home was 10,632 kilowatt-hours (kWh). Or about 886 kWh per month." That's about 30 kWh per day; my community has 45 houses, so use of 1.35 MWh in total, so a megapack will provide power for 3 days for the community at a cost of ~50k per house. Probably not worth it and I'd expect 3 days to be overkill. But a community that was double our size will have a cost of about 25k per unit for 1.5 days of power - which doesn't sound too bad to me.
Another thing I've found interesting is Anker seems to be getting into the home power business - https://www.anker.com/anker-solix/home-energy-solutions?ref=... - which I'm hopeful about, since it doesn't seem like anyone except Tesla has been able to make something that feels simple/easy/attractive. Every time I've look at Powerwall alternatives I'm been unimpressed by the offerings; maybe Anker can deliver.