Try Fallout 4. That has a bit of everything you need with the settlement building system, also includes a campaign if you get bored of the settlement management.
The campaign is that thing that happens when we go scavenge for building materials?
Fallout 4, after generous amounts of modding, becomes a truly wonderful settlement building game. The fact that settlers actually come in and use and take advantage of the stuff you build actually gives a sense of purpose to building a base, which to me makes all the difference. Purpose is what I always missed in dedicated base building games like NMS, Empyrion, and others, which is why I never stuck around with those for more than a bit.