I've got a large ground mount solar install I put in a few years ago (15.9kW nameplate, though mostly east-west facing panels so a bit less annual production than you'd expect, just more "sunup to sundown" production), and it's been a chilly winter, so with an air source heat pump and keeping the house fairly cool, I'm still net +4MWh from the grid in the last 4 months.
Meanwhile, when it warms up a bit more, I'm generating 10x what the house uses during spring/fall mornings (10+ kW production on a sub-1kW house draw for long periods of the day). It's not a big deal with only a few people on the grid, but if every house were doing this, it would be a very big problem for grid stability.
I've also got experience with the off-grid lifestyle, as my office is 100% off-grid/standalone, and I don't pretend that system is cheap. Just neat. And even with 5kW of solar hung for a ~100 sq ft shed, I still need propane or a generator in the winter every now and then to keep things sane in here.