I live in the Netherlands. Sure, we have a reliable power grid that doesn’t go offline for hours or any frequently to make a case for grid backup, but the power companies here charge heck of a lot of money for power. Think about it. The utility company commissions a solar farm (lower cost than roof top solar), but surely hire a 3rd company to operate the farm ($), and then the utility company wants to make $ for their shareholders, therefore, we end up paying a lot of € to cover these.
Now, I have as manay panels as I could on my roof (10) that generates more than my average use in the Summer. I run a heat pump that can heat & cool and Ioperate it when the sun is shining. I do laundry when the sun is shining. Because of net metering, my grid usage practically cancels out against my solar energy production. When the net metering subsidy goes away, I’ll install a reasonably sized LFP battery at home to smooth out day/night patterns, and possibly covering the occasional cloudy days right after a sunny day. No power costs from April to September already pays the cost of my panels in just 5 years. It is free money(as in I save it from going from my pocket to the utility company and their shareholders).
So, it does make sense. Atleast in many parts of the world. If you live in a part of the world with super reliable grid _and_ low prices, or you’re so rich as to not care, then probably, it may not make sense to you :-)
I was just talking about it with some friends from South Africa. They said almost every household there sort of needs to be energy independent because the power company is in the ruin. So, solar + batteries it is. What would you do otherwise?