As a European I was really surprised at how cycle-friendly San Francisco and Palo Alto (especially Stanford campus) are- its much better than you might expect. Room for improvement, but no worse than many cities over here.
What surprised me though is how overall passable public transport in San Francisco was. MUNI and BART are pretty okay for getting around even if locals don't believe so. Unsurprisingly whenever I was in trams, they were full of other European tourists.
Moving around the most urban cores outside of rush hour, you typically won't see the worst of the warts.