It depends less on the size of the project than on which functions of the house it interrupts. Living through construction is mostly about kitchens, bathrooms, heat, water and safe circulation.
Projects where staying is usually realistic: an addition that's largely built outside the existing envelope until the connection point, a secondary bathroom, a basement finish, exterior work, or a single room that can be sealed off.
Projects where staying is hard: a kitchen renovation with no alternate cooking setup, work on the only full bathroom, anything requiring extended heat or water shutdowns in winter, and whole-house renovations where dust and access are unavoidable.
There's also the part nobody quantifies. Construction starts early, generates noise and dust, and puts people in your house for months. Families with infants, anyone working from home on calls, and people sensitive to dust often find that a project they could technically live through isn't one they want to.
If you do stay, the details matter: sealed dust barriers with negative air where appropriate, protected floors and pathways, a defined work zone and a defined family zone, a temporary kitchen if the real one is down, clear daily start and stop times, and a plan for how the crew enters and where materials stage. Ask any builder how they handle these before you decide — the answer will tell you a lot.

