Finally putting in some thoughts of my own, although I find that a lot of it has already been said. I got these books for Christmas and it's taken me till now to actually finish reading the full trilogy, which I think is a sign in itself. I have read and absorbed the various arguments being made on both sides in this and the previous threads, and they have been erudite and persuasive. But for myself I must admit I come down on the more "disappointed" side.
I can't say the arguments in favour of the choices made are objectively wrong, and indeed I always read reviews precisely to get other perspectives. So I can understand that intellectually. But emotionally, my experience while reading was definitely "this is too depressing, violent and sad to be enjoyable."
Maybe I was simply not in the frame of mind - I'd already been drifting away from TrekLit gradually over the last few years in response to some of the story directions, and I was ready to let it go in peace. Then I got myself excited in the run-up to the trilogy's release. Then, as Thrawn well explained many pages back, the product ended up simply not being what I'd hoped for.
Here are some things from TrekLit's 20 years of stories that this trilogy didn't touch:
Well said - I couldn't see this trilogy as a "culmination" of 20 years of storytelling so much as just "the last thing that happened." Little here occurred as a result or follow-up to those stories, it was a separate story that just happened to the same people. Your idea about the Khitomer Accords, the Typhon Pact and the Dominion all teaming up (and the Mirror Universe if we must) because they realise this is bigger than any of them would have been pure Star Trek.
And I can see the reasoning behind making Picard and the
Enterprise crew the central characters – Picard is literally the central character of all 24th century Trek now, and his crew by far the most recognisable. But as also said, that's precisely why other people should have got more attention – they've had enough of it already. Meanwhile so many Trek-only characters to whom we have become so attached got nothing – they were line sayers and button pushers, then they're dead.
Of course, it's pretty clear to me that Dayton, Jim, and Dave weren't bothering to stay consistent with DTI's temporal model (or indeed with the novellas' continuity regarding Agent Ranjea), so that's probably not what they had in mind. But it could bring readers some comfort if they want to believe there's still a version of events where all the novelverse characters get to live out their lives.
The First Splinter Timeline is my favorite version of Star Trek, too. But I think one nice thing about Coda is that you could interpret it as implying that there's another timeline out there that's virtually identical to the First Splinter Timeline that's still ongoing.
Here, I'll raise you one better. Maybe it'll put your mind at ease a bit: Maybe the literary continuity we saw in every single book prior to
Coda actually took place one timeline over -- call it the 0th Splinter -- and that was virtually identical to the First Splinter, and the 0th Splinter is still continuing alongside the Prime Timeline. In fact, arguably I've got textual support for that idea, since
The Good That Men Do established that Jake and Nog survived into the 25th Century while
Coda featured Nog's death in 2387.
I spent a lot of time assuming / hoping that the minor continuity errors – Ranjea still being alive, Hegol being killed in book 1 then alive in book 2, Troi's daughter being born on Droplet when actually she was born on that other planet while Riker was trapped on Droplet – were actually hints that we were already in a slightly different timeline, or that we were somehow slipping almost unnoticed between timelines as the story progressed.
But no, I guess they were just continuity errors, of the kind that have been appearing more and more lately. I guess we can use that to say the "real" TrekLit continuity is still out there, and this was just the death of a continuity that was 99.99% like the TrekLit continuity.
Random question. When Bashir died there was mention of something about him curing some Romulans of a disease on Alhaya, I think. I don’t recall what this was a reference to.
I took that to be a reference to
Abyss, when he stopped Ethan Locken from launching a plague torpedo at a Romulan colony. But if so then that's another continuity error, since the planet is question was Orias, not Alhaya. So maybe it was referencing something else.
#4 As for Voyager, though not stated, I figure that the same fate awaits them. They reside in the First Splinter U. Maybe a scene involving Tom and B'Elanna that showed their distress at their inability to communicate with their Voyager family so far away at such a critical moment for everyone?
- The universe unraveling without more intimate interludes. This could have been a place where we could have at least seen some of that great worldbuilding of the litverse, if not anything but to watch it get sucked up.
- Riker doesn't get his head cleared until the very end, cementing Titan's crew as the worst crew in Starfleet. I feel like Titan's characters got shafted even more than characters that didn't show up. They got to be in this and the previous book quite a bit, all to look stupid.
- The death of the Titan crew. I really, REALLY enjoyed the Titan books way back when, and rather than a last hurrah for them they get to act dumb and then then die off-page like five minutes after finally getting on track. Poor freaking Torvig.
We also had no final scene with Kasidy or Jake - they escaped Bajor's destruction, but so what when the universe is wiped out a couple of days later? Spock was last seen saying "well, that didn't work" and then had no final moment. And did I miss what happened to orig!Wesley after old!Wesley came through the gate? Some people seemed to get forgotten by the narrative, and others weren't in it at all.
I realized a while back that it does kind of make sense that the Borg could have more than one origin. After all, their whole deal is to assimilate other species/technologies and homogenize them with their own. So if there were two (or more) different expansionistic cyborg hive minds coming from separate origins, and they encountered one another, it stands to reason that they'd absorb one another and become one.
Kind of like
Doctor Who's equivalent villain – Capaldi's "The Doctor Falls" established that the Cybermen aren't a "species" per se, they're just a thing that happens when other species face an environmental disaster and turn to technology to save them. Consequently there can be lots of different origin stories, and nothing to say they aren't all true or couldn't all inter-assimmilate.
- Riker coming in at the last moment (as is tradition)
Ha!

I never thought of that, but of course you're right!
But without the First Splinter Timeline and its denizens, all of reality would have been destroyed -- including the Prime Timeline. Every time you turn on an episode of Star Trek: Picard, Star Trek: Discovery, Star Trek: Lower Decks, or Star Trek: Prodigy, all of those characters owe their continued existence to the sacrifices made by the inhabitants of the First Splinter. I think that's pretty important!.
Ultimately I think this is the best final outlook on it. If this is the story we got, which it is, then this is the best interpretation to go with, the one that leaves the best possible taste in the mouth. I too wish they hadn't had to die, but on a meta-level and a character level both, I can accept it with this as a guide.
.