In San Francisco's Potrero Hill District you can find the city's curviest street; I know many of you are saying "No, that's on Lombard Street!", but no, it is actually on Vermont Street.
Notice Coit Tower in the distance as well as bay views etc.
Not quite as pleasing. It's still pretty cute I think; here are pictures on the way down.