Destroying a whole valley for hydro is something locals could easily oppose. Similar with huge solar farms. You can be a proponent of a technology but anti a particular project.
Happy for other examples that would demonstrate nuance, but that isn't it.
Locally there is opposition to gold mining. People in the region oppose it and with a broad definition of ‘NIMBY’ you’d be right. But neighbouring valley, town, region etc is a broad definition.