Places that you specify will require you to take a cab or BART (Bay Area Rapid Transit). It's a good 20 min. drive to the city from the airport, and BART is about the same, though probably a cheaper bet. You can take BART straight up to the international terminal at the airport.
The infamous shot that you speak of was taken at Bayfront park, with planes landing on the 28's.
I'll consider coming out and meeting you if you'd like a guide to be around.
Hope this helps!