It’s not as far off as you might think - even for individual homeowners. I’ve got a far from ideal house with a 8.4KWh solar array on my roof and 3x Tesla Powerwalls in my basement. Yesterday I produced 43KWh of electricity and exported 27KWh to the grid. The only reason I’ve needed grid connectivity in the last nine days has been to export power. In essence, I’m largely off grid from March through October.
Now, this wasn’t cheap (thankfully incentives made it more affordable and Eversource provides the most expensive electricity in the United States), after incentives it was about $22000. That’s a lot, but it’s not hard to imagine this becoming scalable in the near future for climates with better solar potential than Connecticut.