Real estate is fundamentally about optimism. Two terms of Gavin Newsom have provided the opposite — and his replacement could be worse.