When buying our house we had a max size of around 2200 sqft. We didn’t see any use for something bigger. Current house is 1700 sqft and very happy with it.
A bigger house is just more money to buy, higher property taxes, higher insurance, more to furnish, more to heat/cool more to clean and maintain and we end up with more stuff.