Other than location and style of property, square footage/meterage is always one of the first things we look at when buying a home.
We were only ever three in family - apart from when DS was at uni and for a while during the holidays his GF stayed with us too - and our houses ranged from a 900 sq ft 3 bed when he was a baby/toddler, up to a 3500 sq ft six bed semi.
In between there was a 1600 sq ft 5 bed and a 2000 sq ft four bed, both detached.
The 3500 sq ft never really felt too big as we often had my parents visiting as well as lots of DS's friends for sleepovers etc. It was a beast to clean and heat though 🙄 and I do think some of the bedrooms were overly large (20' x 15'). We ended up with way more sofas than three people actually need, lol!
Since DS left home and there's just been the two of us, we've downsized to a 1700 sq ft detached that only had two beds on the first floor but five reception rooms on the ground floor. When we sold it was to a family with two teens and three DC under six! Fortunately we'd added two extra bath/shower rooms so there were three in total. I know they extended the kitchen into the existing conservatory and think they've since moved on.
Our next house was a 2000 sq ft five bed attached that we extended to 2500 sq ft by building a huge kitchen extension. That did end up feeling way too large for the two of us (plus three cats and two dogs!) but was purchased by a family of five when we sold. I imagine it suits them far better 😉
More recently we bought what was described as a detached two bed cottage - although originally a mill, it was converted to a three bed/no inside bathroom during Victorian times - of 1400 sq ft. This feels tiny (!!!) compared to what we've been used to (spoilt, I guess 😉) and next year we'll be adding an extension to provide extra living space, possibly a third bedroom too as the original third bed is now the family bathroom. What we miss most though is the storage we had in those larger houses. As a consequence we've made adding built in storage a priority here. We also completely reconfigured the layout to make better use of the space/position of windows etc.
Imho, although we've owned what are admittedly some pretty large homes, I think layout/storage/the way you use the space is paramount. For example, our 2000 sq ft four bed detached was packed with original built in cupboards and apart from the main bedroom, the others were small doubles which was perfectly adequate compared to the 2500 sq ft 5 bed which whilst bigger/rambling didn't feel such a good use of space.....