The moment I notice a fabric chair is worth it is halfway through a long dinner, when everyone's still sitting there talking and nobody's shifting around trying to get comfortable on a hard seat. That's the whole pitch. Wood and leather chairs look great for the first twenty minutes. Fabric is what gets you through dessert.
The gap between a good one and a bad one shows up fast, and it shows up in places you wouldn't think to check first. Cheap ones have fabric stretched over foam that's already started going flat in the showroom, stapled on in a way that puckers at the corners within a year. Good ones have the fabric pulled tight and tucked properly, no visible staples, no puckering, and the frame underneath is solid wood, not three thin strips glued together and hoping. Push down on the seat in the store. If you feel the frame flex or hear a creak, that's the chair telling you everything about year two. The joints matter more than people expect from something that just holds a seat cushion, because a dining chair gets pulled out, sat in, leaned back on, and bumped into the table edge probably four times a day. Weak joints loosen. Good ones are doweled or mortise and tenon, not just glued end grain. As for the fabric itself, a performance weave or a tight weave cotton blend shrugs off spills far better than a loose linen look, which is gorgeous and will hold a red wine stain forever. Ask before you buy whether it's actually treated for stains, because "wipeable" printed on a tag means almost nothing.
Where fabric chairs go wrong is anywhere wet or anywhere small children eat unsupervised. A breakfast nook with a toddler flinging yogurt is a leather or vinyl situation, full stop, and I say that as someone who has scrubbed a cream fabric seat pad with a toothbrush at eleven at night. They're also not the move for an outdoor dining set or a sunroom that gets direct light all day, since fabric fades and weakens in strong sun faster than you'd expect. Where they do real work is around a regular dining table in a room people actually live in, mixed in with a wood table top, maybe two fabric chairs at the ends and simpler chairs along the sides so the whole set doesn't feel matchy. A patterned seat against a plain table calms a busy room down instead of adding to it.
I'd put a low pendant light right over the table, close enough that the glow catches the fabric texture at dinner instead of washing it out from above.