These two forces work in opposite directions of attraction. Because the country is less urban than Western Europe, the most attractive places to live are not exclusively the big 3 cities. Our wealthy people are pulled away from the cities as much as they are attracted to them.
Meanwhile, a lot of national problems - drug addiction, homelessness, mental illness.. are essentially handed down to cities to deal with. Blue cities by and large have more social services, shelters, lax drug laws, needle programs, etc.. which attracts people who have these problems. Further, some cities like NYC have laws on the books that essentially force the city to provide a shelter bed for anyone who wants one.
Right now we are seeing this made worse by NYC absorbing a disproportionate number of migrants which are then the cities responsibility to house/feed. Wherever you stand on migrant policy, NYC has received a number of migrants equal to the pre-existing number of homeless shelter beds, at a time when shelters were at a an all time high utilization. So our homeless/shelter budget which is already higher per capita than most of the rest of the country just needed to double.
So blue cities end up with disproportionate number of problems they need to solve.
Like we can lock people in jail for violating drug laws.
Or we can allow drug use & provide clean needles.
But it is very very hard to pass & enforce "we will force you into a rehab house" or "we will force you to take addiction treatment X / mental health drug Y". The bar for this type of intervention is very high, and ironically higher than "you broke a law and go to jail now".
One frequent response to this point, is for someone to say "I'm open to decriminalization arguments, but I'm not supporting anyone who says 'The entire country has to adopt my policy in order for it to work!'" Which sounds reasonable, on its face, but in this case it seems like it really is the best option.