I'm a Bay area home owner. We bought 4 years ago. For us it was a great choice. Our our first child was 2 years old and were looking to find a place to settle down and live. We didn't want to worry about rent going up 30% to re-sign a lease. We wanted a place where she could go to school and not have to move around each time a lease is up.
In the end it turned into a great decision for us. The house went up 350k in 4 years and we are looking to cash out and move to a cheaper area where I can take my remote job and pretty much buy a house in all cash and not worry about a mortgage anymore.
So it really depends on your situation.
Are you willing to stay in a house for 5+ years. If you want to sell.. can you ride out a dip in the market?