Years ago, when I was in electronics school, there was a saying they kept telling us:
“We will have abundant solar-powered houses when someone figures out how to run a sunbeam through a meter box”.
You can have it today, if you want:
With the utility companies buying excess electricity (and they have to, by federal law), the home ends up with a net zero energy consumption.
Technology is still a bit expensive, so a $150,000 house ends up costing $200,000. But the net zero for utility bills would easily make that a moot point.
This is where it’s going to have to go. As you suggested, energy companies are not all that pleased about it. But builders and home buyers don’t care.
I expect there will be some attempts to repeal the law that makes utilities buy home-produced energy at standard rates.