That is a trick question designed to make people argue and feel like there is some science or math to it. There is not. Nobody here can accurately predict weather far out enough to be a factor in this decision. The truth will vary by demand by family which may have variability throughout the year or decade. Another variable is the number of cloudy days which will vary as climate changes.

The answer is somewhere in the neighborhood of as much as one can safely store and afford accepting that batteries have a short life. Much like wells in cold climates the batteries should be in an underground insulated vault made from higher quality concrete as to keep fire hazards away from the home. That is also where whole-home generators and fuel belong, in their own vault so they can be easily maintained without having to rent an excavator to dig out the tank.

Even on cloudy days you can generate power. Unless it is very thick clouds I generate enough for my base loads even in complete overcast skies because I have an "excess" of PV panels.