I've been playing for some time using dfhack's "autolabor" feature, and it streamlines things immensely.

Granted, it ends up essentially just turning on every profession for every dwarf, but it's still possible to restrict workshops to certain dwarves. For example, you might have a carpentry workshop set to produce endless amounts of wooden shields, but only allow skilled carpenters access to it.

Yeah Rimworld does pretty well. I wish it had Z-levels, so I could, like, master the technology of "the basement", but in terms of user interface it's pretty good. There are some mods that improve on vanilla's interface, but the default UX is still solid.