My group has played through several of these, we are running a home campaign not as a part of a living campaign so that’s a factor in my feedback.
First, a lot of them are short, very short (Tug of War was maybe an hour of playtime).
Most importantly, they aren’t episodic enough. While it’s nice to have an over-arcing seasonal story a few too many of the missions revolved entirely around that. This is especially silly for a living campaign where players drop in and out regularly or the episodes get played out of order. Also along that, way too many end in cliffhangers!
There also doesn’t seem to be enough variety in the antagonists. I know the Romulans and Klingons are the closest to the expanse but maybe introduce some more minor powers? In TNG you were always encountering new minor powers like the Talarians, Tamarians, and in TOS you’d get Tholians, Gorn. Maybe introduce some new minor powers for the Expanse? It just gets tiresome always dealing with Romulans, as tiresome as it was getting in the TV show (which is why the Cardassians were created)