Bullitt. Steve McQueen. The car chase.
When I went to SF for a friends wedding, my mom, wife, and I ended up with this really cool Taxi Driver who took us around to some Bullit locations for no charge. We three were talking about it, then he joined in too. Very cool.
Also, Big Trouble in Little China is set in SF, but doesn't really do too much for the area. But, walking thru Chinatown is so much fun after seeing this. I just keep thinking about secret tunnels underground there.
The Rock has some nice visuals of SF. Although, when we went to the Palace of Fine Arts (where Connery meets his daughter), it was closed. They said chunks of the ceiling were falling fown so they had to close it.
Nash Bridges had some good views of SF even though it was a TV show (and some of it was filmed in Oakland). Actually got to see Don Johnson filming a scene and driving the Barricuda near Union Square.