I hate to repeat this old adage, but in case it helps to see it here: if you've been wanting to buy something, and you see yourself staying in the area and the place itself for many years, and you have some savings buffer if things go south, then buy. Don't do it because you want to magically have paper equity gains in the next 12 months. Do it because you like the place you're looking at, the neighborhood it's in, and because you have enough funds in place to get through a downturn if a layoff happened.
Of course I say all of that and it's good to know what could happen if a terrible downturn does happen like in 2008 (even the nicest Bay Area hoods prices dropped 25%+).
Last thing, single family houses, especially in the Bay Area, are typically more insulated from price drops (insulated not immune). If you can afford a small single family then it might be worth it, especially if there's expansion potential (either for yourself or the next buyer if you decide to move on). And even better if there are some cosmetic problems that are tractable because let's say you do get laid off there's nothing like building some sweat equity in the downtime.
Just my two cents having gone through similar in the past.
FOMO is a powerful emotion, but like all emotions its a bad idea to make it a primary decision maker for any important matters.
Reading all this from distant Europe, its interesting (and logical) how in US the swings in prices are so extreme in both directions. In fact, most things in any regard are way more extreme in US compared to Europe. May be good for the lucky ones but long term stability or dependability this ain't.
So what you’re saying is, if you want a condo, just wait, because a price drop soon means your money will go a lot further. If you want a SFH, buy now, price drop will be small.
I know a lot of people in the Bay Area who did exactly the opposite in 2017-19, looking at how prices doubled, they assured me in 5 years their investment would double as well.