Ceiling fans in general are a great thing if you have a place that allows for them. Nothing like getting a breeze from them on a hot summer's day. From the point of aesthetics you usually need a large enough room and furniture spread out in a pattern that aligns with the fan. I also like it when ceiling fans double as your light source.
If they work as they should, I have no problem with them. They can, however, turn into a nuisance if they make too much or the wrong kind of noise. But that is an issue of quality and maintenance, rather than an inherent problem with ceiling fans.