> I never got into these types of programmatic games for precisely this reason but I'd like to understand other perspectives on this.

Everything you describe requires interaction with people. Those are too often toxic, incompetent, overly demanding and keep changin schedules and priorities. At least in single player games you get to drop all that crap.