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.
Living in a 12’ wide rowhouse atm, I def think the sweet spot is 16-20’ wide, 50-80’ deep, and 3 stories with a partially finished basement.
The problem is that is a pretty big house. Thats 5500 sq ft on the high end and a little under 3k on the low end. You definitely need to house more than one or two people in them.
I live in a 15’ wide row house, and I could use the extra 2 feet. I think 17-18’ is good, and 50 feet long. That makes about 2700 or so square feet with a finished basement.
What many people do in my area is live on two floors and rent the third out as a (nice) 1-bdrm apt.