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.