If we're talking really good dining chairs with upholstery only on the seats, I would be thinking "If I make a mistake, I can always reupholster." With kids, I might go for a less expensive protected leather, a decent quality fabric and some cans of Scotchgard (testing on a fabric scrap or non-visible area before general application), or one of the new super fabrics that resist most stains.