Allow me to offer an alternative to Lombard Street, but it's not in the US.
There's a winding road in Urzig, Germany that takes you from the Mosel River Valley to the top of the ridge. It may not be as scenic as Lombard Street (which I have visited), but the natives are far friendlier than the average San Franciscan.
I drove that route every day my last 2+ years in Germany. On a nice day, the Mosel would unfold for 10 miles in both directions, and the stress just melted away.
Urzig is the home of the famous vineyard known as Urziger Wurzgarten, which I look forward to visiting again in a year or two.
This pic brings back fond memories:
The wine is world-class, too!