NYC is not going to appeal to everyone (duh) but it has its allures and attractive aspects. When I hear folks running it down as if it doesn't, I figure I'm listening to a person who maybe was there for a day, or less, same with any other Big City.
I have walked quite a bit in SF over several trips and outside the Tenderloin District, the city is pretty decent. There is a lot of blowing trash. LA is not my cup of tea for obvious reasons but I have had some excellent experiences there in the past. I liked Seattle, but we stayed downtown, it seemed to me like an interesting city, rather expensive in terms if living there and the climate can be, um, suspect.
I try and take every city and location for what it is without preconceptions or notions or what I heard on X News.
I often tell folks who ask me about Paris that it is my least favorite city in France, which they take to mean I dislike Paris a lot, which is not really true.
But, human beings often like to run down "other". It's fascinating.