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.
I lived in something like this until recently and you’d be surprised how little I heard of my neighbours (basically nothing except their piano very faintly sometimes). Good walls can go a long way I guess