I've photographed that bridge probably 8 times since I first got a DSLR and started making trips back there to see my fam. Have never gotten tired of photographing it, will never get tired if seeing it
I am from the Bay Area and I still think it is one of the coolest sites to see from around the world. When you are at Battery Spencer, you feel like you are right on top of it and you get to see the city in the background as well. Never gets old.