The concept you’re looking for is called the ‘missing middle’. People assume the only two options are single family home suburbs or inner city mega apartments.
What’s missing are small mixed areas (which are illegal to build in most of the US) that have single family homes, duplexes, small apartment buildings, all mixed in with commercial spaces like grocery stores and restaurants.