My hubby and I recently visited San Fran from Arizona. We took the cable car from the Pier area up to Lombard Street. It looked just how I expected it to, but it had more impact in person. The flowers were beautiful! From there, we walked up to Coit Tower (a hard walk!). Sure, there's lots of tourists around taking pictures, but this is a uniquely San Francisco experience and you have to do it at least once!
Cons: Can be crowded at times