Seems as though most wind turbine advocates think these smokestacks with blades...usually sited in large groups on ridge tops and open areas, aren't unsightly because of their anti fossil fuel image.
Visual impacts are pretty much universally considered in developing environmental impact statements for wind farm projects, and typically draw significant public comment. A draft EIS will typically include renderings showing what the project would look like from certain vantage points, both at night and during the day, and will consider alternative locations to minimize visual impacts. It's also common to consider visual impacts not only during operation, but during the construction phase as well.
For example, here's a Final EIS for a project off Cape Cod:
https://www.energy.gov/sites/prod/files/DOE-EIS-0470-Cape_Wind_FEIS_2012.pdf
I haven't seen anyone argue that the visual impacts are not worth considering due to the fact that the turbines produce energy without burning fossil fuels. To the contrary, sites are generally selected to minimize visual impacts.