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 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.