My home's PV produces more energy than we use in a year, including heating. But the ~1:10 swing in generation from my roof in London UK between mid-winter and mid-summer is tough, and the storage to cover that interseasonally would currently cost about the same as the house and/or use ~50% of its volume. However, we import minimally in summer and export like crazy with the help of relatively modest storage.
Luckily there is this thing called a grid, and the UK has a lot of anti-correlated wind generation on it, which helps a lot.
All my detailed stats are here:
https://www.earth.org.uk/energy-series-dataset.html
Also see: