I've seen this proposed for various things like onshore wind farms (e.g. https://www.bbc.co.uk/news/uk-politics-60864097), but there usually has to be a limit to the subsidy/discount/bribe - otherwise it wouldn't be viable for the company that wants the infrastructure.
I saw something suggested in the region of 25% discount on electricity bill for people near such a site, for up to 10 years. I don't think that such a temporary benefit would be enough to convince me of having something nearby if I thought it was permanently detrimental to the neighbourhood or my property. (Not that I'm claiming to be a NIMBY).