My wife and I live in the SF Bay area and we own our primary residence. I would love to see real estate prices collapse. Why? Because we would like to do a lateral move (i.e. sell our house and buy a different one in our area for about the same price) but right now it's too expensive. The price of both our house and the one we'd want to move to have both doubled since we bought ten years ago. If we moved today we would have to pay capital gains tax and our annual property tax would nearly double. If housing prices collapsed and went back to where they were when we bought we could make the move essentially for free.
That's the insidious thing about rising housing prices. In order to cash in on your gains you have to actually sell your house. But then you still have to live somewhere.