I have ceiling fans in several rooms and find them great.
However when it is extremely hot, as it often is here in Perth, I find they are not a great deal of use, and I always turn on the airconditioners.
When it is just a bit hot, I will turn on the fans and they are great.
I also have one over the bed however that one, although it is good at night, makes a whirring noise and disturbs, and annoys me, so I often end up turning on the air conditioner in the bedroom also.