I have ceiling fans in both living rooms, as well as aircon. They are part of my house cooling armoury.
Passive cooling first with doors and windows, then fans, air con last.
The back living room is the one with the light, and it works very well, very quiet. One thing, though, you can hear it in the bedroom above, through the floor.
Make sure your ceiling fan has summer and winter settings, I think most modern ones do, well they do in Australia. Summer setting pushes hot air up, winter pushes it down. I use the winter setting to make heating more efficient, very much needed with high ceilings.
I change the settings when the clocks go back/forward, and clean the top of the blades at the same time. You need a ladder to both, so get both jobs out of the way at the same time.
I don't get the aesthetic objections bit, but imagine it's because people aren't used to seeing them, so they "interfere", but then so do aircon units on the wall, and radiators. It's what one is used to.