I just finished all the missions with 100%. The balance is pretty good. They are hard, but not impossible. The only one that I have an issue with is The Captain's Gambit. It's fairly easy if you outfit all the ships with sparks, xyphos, renegades, and daggers. The issue is getting all the carriers to actually engage the tyrant. After killing all the other ships, they just kited away from it. Only the fighter only carriers sent their wings against it, doing almost nothing. I had to run the tyrant out of CR and then switch to a carrier to bomb it.
Ah nice! Hope you had fun with those!

Hm, as far as the carriers in The Captain's Gambit, did you keep the stock loadouts on weapons?
AI wise - The Epiphany is a pure carrier, and won't engage directly without Full Assault + Eliminate command and may even need a reckless officer if facing a capital with the firepower of the Tyrant.
**Edit** You probably know this already, but just in case: a combat carrier or carrier defaults to the "Fighter Strike" command when mass selecting ships and right clicking enemies on the tactical map. If you want the carriers to follow an "Eliminate" command on the Tyrant, select the Tyrant itself and then select "Eliminate" under the available commands for that ship and
then mass select your carriers and right click the Tyrant to assign that specific command to them.
The Apogee, on the other hand, is a combat carrier, so it should be more willing to directly engage things. That said, they are default equipped for long range missile strikes, and so would be pretty unwilling to engage things directly no matter what orders you gave them. Their Twin Tactical Beam is just a deterrent for the stray destroyer or frigate that gets too close.
The direct engagement vessel in this scenario is the Hyperion. Though, that ship will struggle against the Tyrant: A single volley from its main battery is enough to one shot you, in most cases. You are supposed to whittle it down and distract it with coordinated fighter strikes as your carriers flee, and let it burn its ship system so it can't turn fast enough to get you within a full batteries' arc.
Even then, one of the harder missions to do the upfront way. The running it out of CR solution is not the most fun of scenarios... may look into that.
