Large wind farms are located in area with the highest wind energy potential, which in our case is western Oklahoma. I agree that they would look great around the city, however, the ground clutter of building, trees, etc. would slow the wind down substantially.

Building-mounted wind turbines can work, however buying wind power from larger farms is still by far more cost-effective.

As for noise, they are not really that loud, must less noisy than an interstate.