Like anywhere, it can help to stand out a bit, and being a straight white guy without tons of money who works with computers is about as far from 'standing out' as you can get in that area, from my experience. I was a lot happier from that point of view when I got out of there and moved to Italy, where I ended up meeting and marrying a very smart and beautiful woman.
On the subject of "gay", something that I liked about the bay area was that gay is pretty common, and of course accepted and so it's just something that is, rather than someone's "defining attribute", so it's not this big deal. That's how things should be.