I've lived in the same neighborhood for nearly 24 years. Until 2019, the longest power outage we had was a 6 hour blackout when we received nearly 4 feet of snow in one big storm. Then we got our Powerwalls installed last year and had a 45 hour outage after receiving only a few inches of snow in March 2019. The Powerwalls kept things running great the first 24 hours but then had problems with our inverters the second day since the Powerwalls were putting out too high of a frequency for the inverters. Tesla fixed the issue the next day by updating the inverter firmware.For myself it would simply save me the inconvenience when the power goes out. It's a bit weird because a few years back I hardly ever lost power, and now days I'm lucky to go a month without a short power outage to the entire area around me.
Now if I lived in California with rolling blackouts I absolutely would get a power wall. They're probably selling like hot cakes in California right now.
We decided to put things to the test and we're currently on day 6 of an extended off-grid test and haven't had any issues. We got nearly 9" of snow last night so I cleared off a few panels this morning. They are already covering half the household use. Another 30 minutes and the Powerwalls will be charging up again.