There are many different neighborhoods with pretty different feels, but generally speaking I would say this:
The city is dirty, there are many homeless people, public infrastructure is not great (bad roads, questionable public transit), and it is the most expensive rent in the world. Culturally, it is much less "gay" and "hippie" nowadays, and almost entirely "tech," at least in my own experiences. If you're a software engineer, there are plenty of jobs and you will never have issue finding work. The pay, in general, is excellent. If you're NOT a software engineer, I'm not sure.
The city is dirty, there are many homeless people, public infrastructure is not great (bad roads, questionable public transit), and it is the most expensive rent in the world. Culturally, it is much less "gay" and "hippie" nowadays, and almost entirely "tech," at least in my own experiences. If you're a software engineer, there are plenty of jobs and you will never have issue finding work. The pay, in general, is excellent. If you're NOT a software engineer, I'm not sure.