I am set up in a small sitting area located in our master bedroom. It occasionally gets dusty, but I just have to get the kids to vacuum. The drill press is located in my garage. I don't have a sewing machine, but if I did, I would probably find a way to fit it in. I do have a corded drill that I clamp on the bench for my sanding. It is not too bad, I usually vacuum right after. As for the fumes, it just depends. I do have some emergency cans of Tandy Contact Cement, but the wife knows to exit the room immediately when deployed. I did find some green label contact cement at Lowes on clearance in a one gallon. According to their label it can be used for leather and materials, but mostly used on counter tops. What I like about it is that it does not smell at all. I just glue both sides, it dries and CAREFULLY put them together. I haven't had one project split yet.
Good luck