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 know the architecture group Vandkunsten has done some projects along those lines. They’ve designed a 4-person home with 37 square meters, where the concept is to make use of common space. They generally make very cool use of common space.