It's absolutely bonkers how much I pay for electricity while I sit in the shadow of a giant onshore wind farm in Brandenburg. Transmission losses are nothing at this distance and the turbines cover the towns needs many times over.
But because of the lack of regional and dynamic pricing (and tax burden) we pay ridiculous rates.
I think if folks could financially benefit from renewable projects in their neighborhoods, suddenly citizens opposition would fall apart.
Maybe balcony solar is just a tax minimization play, in that the energy you get from panels isn't burdened by excessive network charges, consumer taxes etc.