In my first home, (a trailer), I sewed at the kitchen table. Then the next place, I graduated to a large built-in desk in the boys bedroom. Actually that worked out well because as those toddler kids played, I could watch them. Next, when I had a bigger home, I sewed in my bedroom. Such fantastic light in there, and a big bed to spread out projects to "eyeball" them.
Now I have a large laundry room. That has worked the best. I sew on one side, have iron, dryer top, etc. all handy to work on. and great windows. If I ever had a "dream" home, I think I would purposely choose the laundry room again!