There is a game I kick-started called Stonehearth that fits this mostly. Sadly, it was abandoned by the developers.
There is another one called Timber & Stone which is also largely dead, sadly.
Stonehearth was eventually abandoned, unfortunately, but the game is very much playable. The devs didn’t just ghost the playerbase but had a kind of transfer of knowledge with the modders and the game lives on.
What’s great about Stonehearth is it’s multiplayer. A multiplayer colony management sim where two players can build an interconnected city (technically 2 separate colonies) and command an army to fend off increasingly difficult waves of goblin raids.
I’ve had so many fun games with my wife, we’ll settle next to a cliff side, she has hearthlings (i.e. hobbits) and me as dwarves. I’d take care of mining and build all into the mountain, make us the best weapons with world-class smiths and she’d take care of the food, amazing cooks, animal husbandry, etc.