Ok, I know I said I was frustrated. I was. I took a day off, played some Ode, and went back to it fresh.
And then:

Sure, half the colony was unemployed, and crime was rampant, and we were running out of food, but I did it. I saved all 1000 colonists in time.
There’s just three scenarios left – I probably won’t play the sandbox mode (if I need to build more colonies on alien planets, I have other games for that). I find I rarely enjoy this type of game without very specific goals and win conditions (although an open ended colony builder like Rimworld really works for me).
Maybe when I finish this up, I’ll be ready to get back into something story driven. Yesterday, I cancelled all my active subscriptions (ESO+ and Utomik) until I see how much time & energy I’m going to have for gaming during Day Job’s busy season.
It’s not like there aren’t plenty of things in my Steam library I can play without paying for services I’m not using.