https://www.galciv2.com/twilight/ is the most detailed discussion I have seen.
I'm about where you are Infamous. Having read everything on the forums, looked at the few brief glimpses available on YouTube; it is a hard call to make.
Not upsetting me much since I am stuck in Moo2 at the moment. Moo2 is now available on gog.com for $6 along with Orion 1.
Right now Stardock is concentrating on developing Elemental War of Magic and Brad Wardell is still at work on his book I think. https://www.elementalgame.com/
Somewhere on the forums there is a thread of desired fixes and enhancements for ToTA that is lengthy. When they are going to get time to work on ToTA is unclear. I think GC3 has been talked about, but I don't think a commitment has been made.
It is a perplexing decision, because forum posts tend to concentrate on what is wrong rather than what is right. Leaving me also wondering exactly what I would be getting.
Sins of a Solar Empire forum is sort of quiet these days too. Not sure what Ironclad is working on.