Hi all. First post from a longtime lurker/reader.
My reply to OP is yes, photography is fun. I started in high school with film cameras. Photography has since become my career. I'm currently at my 7th newspaper, as either a photographer or a photo editor. Plus two wire services - shooting at one and editing at the other. I've taught photography here in the U.S. and overseas. There is nothing I'd rather do than photography.
OP, don't worry about megapixels. Don't worry about whether you're using your phone or your DSLR or a pinhole camera. The best camera is the one you have with you.
Likewise, don't worry about the other people taking photos of the same thing. Just look for some good light, find a good composition and wait for some interesting moments. You're not in a competition with anyone else there. Your only competition is yourself.
I hope you make some great photos. And keep your eyes open for other photos when you're not next to the Golden Gate bridge. Some of my favorite photos are from moments I hadn't counted on, going to or from the thing I had planned on shooting. Have fun and let us know how it goes.