The idea that being a SAHM is automatically going to give your DCs the notion that work around the home is women's work (or non-work according to Scottishmummy) strikes me as odd. Would having a SAHD give children the same sort of impression about men? Would this be a disservice to men or to children?
DS can cook and serve a meal and clean up afterwards, vacuum, clean a bathroom thoroughly, do laundry, fold and put things away (no-one irons around here), repair drywall, do household carpentry and minor plumbing, use power tools, prep and paint walls and mop out a flooded basement and assemble flat pack furniture just as well as I can because I have taught him to. He even reads directions. He can also apply plasters to knees of younger siblings, take temperatures, read directions on medicine and administer doses, mop up puke and change nappies with the best of them and in general can be relied upon to hold the fort in all circumstances while I'm out. He wants to be a pilot.
The DDs are not half as interested in developing the sort of general housework competence as DS is, maybe because they tend to prefer things they can learn by studying whereas DS is very much a hands on sort of learner. But they do their chores because you have to start somewhere in the world of working and housework affords a fantastic opportunity to develop skills, good attitude to work, and a sense of responsibility and accountability to the other household members. One in particular has developed the skill of delegation to the point of an art form.
I think if children see someone doing a good, honest day's work, organised and able to train and delegate and run a tight ship in general, then that person is showing a good example to children whether the good job involves cleaning a toilet or running a corporation. Because children are far more likely to see work skills in action in school or at home than in the corridors of IBM, then as far as examples go of work, attitude, management skills, etc., housework is far more useful as a way of teaching children than anything a parent can do in the paid workplace, which tends to be mysterious and hard for most DCs to imagine. I would go so far as to say that a WOHM whose life consists of frantic crisis management, hastily cobbled together meals, etc., is actually teaching a child how not to work effectively. Not saying all WOHMs' lives are like that mind...