My DH sleeps so poorly that even me walking to the bathroom wakes him up. I wouldn't dare try to sew on a machine anywhere in the house at night. My sewing space is upstairs and he can still hear me. I have gone to the living room and tried to hand sew, but he can still tell me when I walked through the house.
I would try a small portable in the dining room and see if that bothers him. Good luck!
