A good office chair holds you without you noticing it. You sit down, your lower back meets something that pushes back just enough, your arms land at the right height without reaching, and twenty minutes later you're still there, still comfortable, not shifting around trying to find a position that doesn't ache. The bad ones announce themselves within the hour. You know by the way your shoulders creep up toward your ears that something is wrong.
In an ordinary room, the chair matters more than the desk it sits at, which is the opposite of what most people plan for. It sits well against a plain desk and a window with decent light, nothing fighting it. Leather or faux leather in black or brown reads fine in almost any room, blends into a study or a corner of a bedroom without making a statement it doesn't need to make. Mesh backs look less like furniture and more like equipment, which is honest, because that is what they are, and they do better in a room that already looks a little functional rather than one you are trying to keep soft and calm. Fabric chairs are warmer to the eye but they hold smells and stains in a way the others don't, so think about what is nearby, a coffee mug, a dog, a toddler with a marker, before you commit to pale fabric.
Where it goes wrong is when people buy for how it looks in a room rather than how it holds a body for six or eight hours. A chair that is gorgeous for twenty minutes of sitting and photographs beautifully can be miserable by lunchtime, and there is no cushion or throw that fixes a seat pan that is too shallow or arms that sit too high. It is also the wrong choice if you need it to double as a dining chair or an occasional seat for guests, most task chairs look and feel out of place anywhere but at a desk, and trying to make one pull double duty usually means it fails at both jobs.
The ones that wear well are the ones with replaceable parts, casters, a gas lift, arm pads, because something will eventually need replacing and you want to fix it, not toss the whole chair. Leather softens and creases in a way that looks better with a few years on it, mesh sags slightly and needs the tension adjusted rather than ignored, and any fabric seat benefits from a vacuum and a damp cloth wipe every couple of months, more if it is near a window catching dust in the afternoon light.
When you're looking at one, sit in it properly, adjust everything before you decide anything.