The polling shows that NIMBYism is alive and well in the US, but at some point we need to have a conversation about the trade-offs between technological progress and community