While the lens makes this a heckuva picture, SFO is really like this...really.
While in recent years the concept of side by side has gone away, stagger by approaches are in vogue.
the real danger is when two planes are being vectored to their respective VISUAL finals and go "belly up" to each other.
From one side (the south) you turn left to intercept 28 left final...going belly up to a plane from the north turning right to intercept the 28 right final. At this moment their is some danger if someone overshoots.
I've flown into SFO with three different small airlines and one very big one.
This happens to allow sequencing of departures off the "ones" (one left and right). It is all an effort to do MORE with an airport that has runways that are too close together and has too many flights.
Except for the fog, SFO usually has nice wx...
BUT really watch out when you have english as a second language foreign carriers...just be careful.