Happy you found my comments helpful. If you want to learn more about the technologies and companies behind the energy transition you can check out this list we curate[0]. I would also recommend reading Project Drawdown[1] for a high level overview of the emerging generation of energy technology.

For what it’s worth, the scenario you describe is basically how the state of the art home systems work in the markets that support them. Distributed generation (via solar), energy storage (via batteries), and bidirectional grid connections for feeding surplus energy to the grid. Some companies even aggregate homes to act as a virtual power plant which can be dispatched on demand. There is a ton of interesting stuff happening in this area, I hope you find an opportunity that suits you!

[0] https://climatescape.org/categories/energy [1] https://projectdrawdown.org