In my experience a lot of people only find Manhattan tolerable because they can get out of the city on a regular basis. Assumes a certain income level of course. But those I know who live in Manhattan, SF, etc. without cars rent Zipcar and conventional rentals a lot. As well as Uber, etc.
Many people are just largely stuck to public transit lines of course. But the demographic that is actually moving into cities (college educated professionals) mostly doesn’t think that way.