I've lived in most different types of place now (rurally, in the suburbs, in inner city suburbs, in the middle of metro areas) etc and the idea of having to decorate a massive house is something I really can't be bothered with. If I had children I'd want enough space for them, sure, but that's about it.
It's not even about the cost but just the mental overhead of it all, cleaning, all the stuff you accumulate, etc.