People live very different lives, and have very different priorities, and this leads to very different decision making.
There are probably some trends that are common among these different groups bad house/good car vs good house/bad car.
Bad House/Good Car - I think most of these folks don't have kids. It would be difficult for most folks to compromise on the living conditions of their children while spending money on a very nice car. However there are plenty folks with no kids that do not mind very modest living accommodations. This then free's up some of their cash, and since we are human we want to spend money on things that make us feel good. Very nice cars can make people feel good. When they are driving around in their corvette, no one that sees them may know they live in a place that some may find embarrassing. They can drive around thinking "I am awesome, and all these people looking at my car think I'm awesome." A very nice house is a much higher expense to get this feeling, and also you only get it when you invite people to your house, not every day when you get in your car.
Good House/Bad Car - Trend is flipped for kids. For the typical family in the USA the "right neighborhood" is important. Often the right neighborhood comes with the right schools, the right neighbors, the right friends for your kids. Americans will spend an amazingly high percentage of their income to get the house they want because it comes with these other things. This contributed to the housing bubble and crisis of ~2008, it didn't matter how high prices got, people picked the neighborhood/house level they wanted, and they would pay whatever it took to live there even if it completely destroyed their finances. This is still a fundamental problem with housing in the USA, I'm not sure it will ever stop being this way. Spend every penny you have on your house and there is not much left for cars. This is probably some portion of the good house/bad car crowd. The rest is probably folks that understand the depreciating asset issue. At least a percentage of the money spent on an expensive house is an investment (you do not get your high real estate taxes back), however every penny you spend on a car is truly a penny spent. You don't get it back. People that understand this and are savers don't want to spend money on a nice car. For these people money in the bank gives them better happiness return than money spent on a car.
Very interesting thing happened with a family that lives down the street from me recently, upper middle class, guy is in sales, wife is a nurse, two kids, plenty comfortable but not rich. They had a for sale sign in front of their house but then a month later it went away. They told us they had their eye on an upgrade house, however when it came time to finance and they actually figured out exactly what their payment would be they decided they couldn't afford it. Two months later a brand new white corvette showed up in his driveway. People want things to help them be happy . . . .