Whether to upsize

We have lived and brought up our 3 children in our current 4 bed home. We currently have 7 adults squished in, including my father and have managed to get by but are bursting at the seams. The adult children and partners should be moved out over the next year. We have been indecisive over the years whether to upsize. A large part is being afraid of making a mistake as we have no issues where we are with neighbours and live in a quiet cul de sac.
However I would love to have better sized rooms for family visiting with future grandchildren etc ( one child lives away so would be staying over when he and family visit) and just more space in general . We have extended our home as much as possible. Husband and I both work from home, we are also interested in offering supported living to age 16+ Young people. What I am interested in from other people’s experience is 1. Did they regret moving from a long term family home and why? 2. We would likely be buying a 4 bed house that is either new build or nearly new and any regrets about that ( for example any issues with the community heating thing they seem to do these days/ management fees etc Thank you