I'd recommend moving Vassago's Dirge up before Age of Aquarius. It's pretty short, has some relevance to War in Heaven, and Blue Planet is so good, you probably will want to jump straight from one to the other.
Also, don't let lack of voice acting dissuade you. It's a huge undertaking and therefore not every campaign can manage it. War in Heaven doesn't have it...yet, but it's still one of the best campaigns.
I'm surprised no one has mentioned Wings of Dawn yet...it's not nearly as detailed as other mods, but one person literally made EVERYTHING from scratch, ships, weapons...everything. And it's a bit more light-hearted than most campaigns, which is a nice change.