I know and feel you, that's wh I have looked into. It seems the biggest issues are bureaucratic (you can either produce power or food, if you want both, it gets murky and you need exceptions) and our bad grid. People can not transport the created energy without the grid straining.

Both can be solved, not sure if Frau Reiche wants to...

But, my favorite German example is the Hop farmer in the Hollertau who built a commercial system himself and is pretty happy (if the grid was stable)