I had the same experience even in Santa Clara County. Google maps led me to drive on unpaved roads along the farms near Gilroy in order to avoid the congested 101. It's not worthwhile, and I'd argue Google should expose an option to let me express my preference.

We probably shouldn't be surprised that a navigation app that tells you to make left turns during rush hour in San Francisco doesn't behave any more rationally in rural areas that aren't a stone's throw away from the company's own headquarters.

Being able to express your preference isn't what Google is all about. Their attitude is that they know best.

I had the same in Italy (Tuscany) with Google Maps. One way it recommended a longer normal road, on the way back it was a shorter dirt road through fields and forests. Had to stop once to let a fox cross the road (it didn't seem to care much about me). In the end it took as much time if not more.

Those rental Pandas can take you everywhere though.

Had the exact same experience with Google Maps in Crete! Although already a few years ago.