I grew up in a city of mostly rowhomes and I love them. Plan on buying one one day.
You still get walk-ability, sense of community and good population density (not as good as a high-rise but still good), but also more privacy, and the space is more conducive to raising a family than an apartment. Also they’re cute as fuck and people can paint them different colors and have cool little gardens on their porches and stuff.
You’re right, it’s a necessity if we want to live in a sustainable world. It’s also human nature - we are a communal species.