It also depends on personalities - my wife and I share 650 square feet, have for years. This year has been pleasant even though there’s no “time apart” and no privacy. We also have a dog in that small area.
There’s more to it than just affording large luxury housing.