For me, the thing I like in building games is when I can make things that then actually 'do something', not because I used the 'do something' block but because of the ways that the various elements work together. I loved making canals in Minecraft that would deliver items automatically to a central collection point, or elevators or things like that. That's part of what I felt like Terraria was missing for me - most of the stuff you build is just aesthetic, not functional; or its baked-in functions like 'build the workstation/furnace/etc and make sure you have one of each' type stuff. Usually the point where Dwarf Fortress gets boring for me is when I've basically finished wiring up the things that need to be wired up to survive, but then there's no goals that I need to design and build in order to reach - its just accumulation or checking the tick boxes for necessary structures - got enough beds?, got enough food?, etc.
I like the idea in abstract that at first you're doing everything yourself, and then you gradually build up automation into the world that lets you extend your agency and scope. Instead of accumulating items in an inventory, you accumulate structures you've added to the world which work together to let you do things in new ways or just on very large scales. I haven't quite figured out the right way to gamify that idea though, in part because requiring things to function through interaction rather than identity is a lot harder to control. The result often ends up being something more like an physics or ALife simulation than an actual game.
If I really want to go off the deep-end with this, I could imagine boiling this down to constructing different kinds of autonomous intelligences that actually become your swarm that you control. So instead of just building physical structures, you're building behaviors that you can deploy - starting from individual custom-crafted robot butlers, and then turning into self-replicating robot swarms and robot societies that you're only controlling indirectly or hierarchically by the end-game. So at the beginning you take your pick and mine out some silicon for chips, but by the end you say 'go, my minions, and eat that planet over there and build me a new factory' or something like that.
Edit: Wow, I just noticed that the above post was kinda old, sorry about that... would there be a better place to bring this up?