General rule of thumb with wind turbines: the bigger they are, the less annoying the noise (and the drop shadows). They are designed for about the same tip speed from smallest to largest (basically: highest rpm that doesn't make tips go too close to transonic), so rpm is inversely proportional to size. I believe that if turbine size was only constrained by structural engineering and not by transport, they'd be almost as imperceptible as jets passing by at cruising altitude (visible from "everywhere" and also audible if everything else is quiet, but perfectly ignorable ambience).
Perhaps your memory of turbine perception is dominated by some examples that weren't quite as big as you might have thought? It's really difficult to judge the size of those things (they are all "much bigger than a house") if you don't deliberately focus on rpm (this little trick only works in reasonably high wind conditions of course)