Songs of Syx would also fit as an example into this piece. It's a city state builder, and you get to layout your own buildings by placing walls, and roofs and beds and workbenches and stuff on a 2D grid, and then builders go and build the stuff you layed out and people work the job stations and live in rooms and such.
I played a bit of it myself and the vibes are chaotic, but want I want to highlight here I really barely experienced myself but rather read about and saw video of, and that's the fantasy race relations system in that game:
Basically, the game has these fantasy races kinda like Tolkien or D&D, except different. Like 10 different races or something in that order. And they all are more or less racist or friendly towards the other races. I should mention that each individual is modeled with with wants and needs and even a sort of personality. And the races all require different and often conflicting amenities, like the types of roads (hard stone, soft dirt, canals), preferred building materials, foods, moisture levels and so on. Different religions add another layer and are not (inherently) tied to race, I thinks there's sort of a class system as well.
The races are also better suited for certain jobs (farming, mining, manufacturing, clerical work, military/police, etc.) and they're happier also if they have the right job. The more your settlement grows the more discontent and conflict the game allows for. Bigger cities I've seen on youtube look insanely busy, and they have crime and race and class related conflict and violence and shit like that.