Food is expensive and a lot of it's designed to be instagrammed. There are definitely some great spots but not that many and really not that diverse (lacks middle eastern, greek, british, American bbq, spanish)
Nightlife is horrible, bars pretty much close at 1am, hardly any live music, gender imbalance, and not much density so it often just feels "dead" in a lot of places
the weather is ok. there's usually a few hours per day where it's pristine but quickly gets too cold/windy. And it's too uncomfortable to eat outside for dinner.
Public transit is unpleasant and slow, so most people who can afford it resort to 100% rideshare. And having your own car here is also a pretty bad experience (though some people would say this is a feature not a bug)
Petty crime is high. My friends regularly have to deal with car break-ins. (yes the same person would have multiple break ins in a single year, and no they don't keep anything in their car)
It's hard for me to speak to the culture, most of my network is in tech, and most people I know intend to leave at some point. Living in a city that people don't plan on living in for very long does not create a very good community or culture.
I live here because this is where my job is and where my friends are, but I want to leave pretty badly. I just don't really have anywhere else to go, if not my home country