Are you talking an airplane configuration, or like a helicopter/quadracopter?
I have one of the A.R. Drones. If there is any wind at all it will tip to compensate, to hold position. If you are using the HD movie camera, the effect is not unpleasant, but not a smooth smooth shot. The built in movie camera makes amazingly good video, with excellent depth of field. On still days the smoothness and quality are superb.
I know they show these things on the news all of the time peeping over someones fence. It would be darn near impossible to not know one is there, because even with electric motors, the fans are noisy.
If you get a bigger one to mount your own camera on, and are taking still pictures, they should work in up to a 10-15mph wind as long as you do not expect every picture to be framed correctly. The most difficult challenge with wind will be takeoff/landing.