Large wind turbines can make a worthwhile contribution. The generating power increases with the square of the blade length, and the wind speed is also higher further from the ground. Also the electrical and mechanical efficiency increase with size.

I personally don't find them visually unpleasant, and their effect on migrating birds has been exaggerated. After all, birds learned to live with windmills from the middle ages to the nineteenth century.