Homewood Suites is designed to accommodate longer term guests. I spent around 2 months in one years ago - full kitchen, separate living room and bedroom. Laundry onsite.
I believe Candlewood Suites is the same, but less "upscale."
I’ve had decent luck with Residence Inn. Full kitchen and separate bedrooms.
The sofa mattresses are terrible though.
I’ve never experienced a good sofa mattress. Have you?
Not that would be comfortable for an adult, but the newer Courtyard King Size rooms have single-person pull-outs that I think are a lot better than what they have at Residence Inn.
The type of standardized hotel room you describe sounds like the small rooms that are made to sleep during the night and leave during the day. Not for "living" in a foreign city.