The thing nobody mentions about a ceiling light is how much of your opinion of it depends on the hour of the day you never think to check. A fixture that looks sharp under the showroom halogens can turn a room the color of a dentist's office by nine at night, once the bulb's true tone comes through and there's nothing else competing with it. I've stood under more than one good looking fixture at dusk and felt my whole mood sour before I figured out it was the light's fault, not mine.
Getting the size right starts with the ceiling height and the table or sofa underneath it, not the room's square footage, which is the measurement everyone defaults to and the one that leads them wrong. A fixture needs to sit roughly thirty inches above a dining table if the ceiling allows it, and in a standard eight foot room you want something that doesn't eat more than a foot of headroom near a doorway or you'll be ducking it for years. The mistake I see constantly is people buying small because the room felt crowded on the showroom floor, when a too small fixture just reads as an afterthought once it's up there alone against all that empty ceiling. Go a size bigger than feels sensible on paper. A ceiling light has to hold its own against the whole room looking up at it, and a room with high ceilings and a lot of trim can carry something with real presence, while a low ceiling in an older house wants something flush or close to it so you're not forever worried about hitting your head on the way to the window.
Which room it suits depends less on style than on what the room does. A hallway or stairwell wants a fixture that reads well from below and from an angle, since you'll see the underside of it as much as the front. A living room with lamps already doing the evening work can take something quieter, almost architectural, since the ceiling light there is mostly a daytime fixture and an accent at night. If you're starting from nothing, get one with a dimmer built in or wired for one, because a ceiling light run at full brightness every single evening is how a room stops feeling like somewhere you want to sit.
They age in different ways depending on finish. Brass will darken and get better with it, left alone rather than polished. Painted metal just needs a dusting a few times a year, up on a stool, same as a bookshelf. Glass shades hold grease and dust faster than you'd expect over a stove or a dining table, so a wipe every month or two keeps the light honest rather than muddy.
Get the right one up there and the whole room finally looks lived in on purpose, not just lit.