I lived in WNY for many years and a neighbor had a wind turbine down the road from me. He was always known as "the guy with the windmill". Post SHTF it will stand out even more just like you said.

For some reason he used it to augment his power instead of charging batteries. From what he said and some stuff I've read they seem to have issues with longevity. If I were to use a wind turbine I'd probably rig it up to be able to go up at night and down during the daytime. This would make repairs easier than climbing a 100 foot pole too. It will still make noise though at night which may or may not be a problem for you.

If you're looking at running your home just off wind power you will need a large windmill or many smaller ones.

One of those windmills outside Warsaw would be nice to have lol.