These are wealth generators in that renters are paying your mortgage.
My grandparents lived in a Queens NY row house (until 1970s white flight). I have early memories of it, was a cool house. It had lots of fireplaces, varnished wooden gates, wall sconces and shared back courtyard. My parents lived in a 1950s single family house, but we gen xers rediscovered cities.
New houses around Boston are mass Lego block low rise apartments. They all are corporate owned, which means they are expensive, and the rent goes up automatically, but they sometimes have nice ammenaties.
SROs: I want to live the way Sherlock Holmes did. Mrs. Hudson cooked, cleaned, answered the door.. did people really live like this in late 19th century London? How much was the rent?