Completely understand, BG–know the areas well. We have quite a few family members in Northern CA, from San Fran, north, who have been there for years, and have also seen the changes you are mentioning with regard to RE prices, etc.
Had their kids not purchased their homes in Sonoma, Napa, and even in Santa Rosa and Placerville, etc., etc., several years ago, they would have been priced out, as these, and other locations up there have become the destinations of choice for many of the SFO elite.
I wish you all of the best in finding what you are looking for, and I’m sure you will.