It is not remotely close to economically viable to go off grid, and the exports of solar power to the grid pay for the connection anyway.
The reason to have a battery is that it lasts through the night, or even with a smaller system, it can handle dinner time, which is the most expensive time of day to buy electricity.
Now if you live in some remote area without a grid, a generator is a way better option than a huge battery.
Maybe if you live somewhere very sunny, like Spain and especially southern parts of USA you can probably do it with a modest battery that can handle a couple of days.
In the summer we can make enough electricity on by far the most cloudy days, but in the winter, the sun can't penetrate the clouds nearly as well.
Admittedly London is south of where I live, which is close to the most southern part of Denmark, but on the other hand London is infamous for grey weather with heavy clouds.

You could probably get by with a gas generator and only run it 2-3 times/year in many areas. It's not 100% green, but it could get you off grid for a fraction of the price.