Also, because it is highly leveraged for many, especially in the Bay, to have it reduce in value can actually easily bankrupt you. But for many, they feel they need to take the risk to lock in home prices, and also to grab what they still cling to as "the american dream" of owning a small single family home. Can't say I blame people for being upset by that, especially after this tax reform theft.
For those people, if their house goes up in value, it represents an important source of financial security (if they haven't gutted it via refinancing and HELOCs for renovations returning $0.60 on the dollar, new cars or vacations)
Even for people with decent financial planning skills, the home is such a large investment and typically bought with 5-33x leverage, that a small price drop is dangerous to their position.
In cities, it is often that bigger appts are cheaper per sq/ft because the market for them is much smaller than 1br/2br.
I own a small house (with a mortgage). I'm hoping house prices go down over the next 10 years. I'll probably want to buy a larger house, so if prices come down I don't have to come up with as much cash. OK, I'll get less for the house I'm selling, but the difference in the prices is also less than if they were to go up.
As long as I sell the current house for enough to pay off what's left of the mortgage, I think I'm winning if house prices go down.