Hello,
B0ka245, welcome to the Tri-Valley RF drain. This is a very difficult area because the high hills create a shadow that causes multipath (variable interference when the same signal comes from different directions at different times). I could write pages about this, as I've lived with it for 20 years, but I'm going to be brief, for now.
The result is very location specific - your neighbor may get better or worse results than you.
A really good antenna (high gain and high interference rejection) with a really good preamp (low noise, overload immunity) up around 30 ft or more is the minimum required. The biggest baddest antenna is needed. XG91 is one choice as noted, another is the Televes Dat Bos Mix LR. You will also need a rotor because the exact azimuth positioning of the antenna is critical, and may vary during the day as the multipath varies.
What also helps is a TV tuner that is good at handling multipath. The best I've found is the internal tuner in the LG OLED TV's. There are many times that the LG can pick up a near perfect signal when no other tuner can get anything stable.
You may also have to experiment with different antennas, different heights, and different locations.
As you've already found, VHF is easier to get than UHF - because the lower frequencies can "bend" more and get around the hill obstructions.
You may have better luck tuning in the Sacramento stations from Walnut Grove than the Sutro stations. Of course, then you'd get Sacramento local programming, not SF. Also, the stations transmitting from Fremont may be much easier to get than the Sutro stations.
Bottom line is that you'll have to be experimental and patient to find something that works - even then, it may not work 100% of the time.
With all that bad news, here's some possible good news coming around the bend: when ATSC 3.0 starts transmitting, it may solve all our problems, because it's designed to deal with difficult multipath situations like ours. But here in the Bay Area it looks like it's a couple of years away.
Hope that helps - it's reality at least.