Whilst not a street intersection, there are some very decent shots of the city skyline looking across the water from Treasure Island - either car or MUNI bus will get you there, exit off the Bay Bridge.