- super dense cities like Tokyo or New York can feel suffocating. A lot of people can't bear it. The lack of green space, and the overcrowding of people and cars increases the stress levels by a lot. Yet, being able to walk around the city is excellent for exercising and mindfulness, it's easier to meet with people, etc.
- super sparse cities (like LA or Brasilia) on the other end tend to isolate people, and to mediate the experience of daily life. Life is constantly split by episodes of driving / parking. Yet, these cities offer a lot of space, greenery and privacy.
The fact that both very dense cities and sparse cities exist and are successful only shows that different people enjoy different kinds of cities, so it would be a bit preposterous to claim that one style is better over another.
That said, electric cars and self driving car fleets will most likely help reduce pollution (both noise and air) by a lot and make living in dense city much easier.