My dream mod (which may some day come about!) was centered on taking a Terran character throughout their military career. Start off as a pilot with a pre-Unity planet-state navy, move onto the united GTA (after a possible "Unification War" scenario) and the TVW followed by the GW. The main character is outside Sol during the node collapse, while the rest of his/her family is trapped in the home system.
The MC then has to spend the Reconstruction and Capella eras trying to get their life back in order, what with being separated from most of their loved ones by light-years of space. The few surviving comrades from the GW would make up the rest of the cast (some of whom may end up fighting the MC during those politically-divisive years). The MC first becomes a ship's CO during the NTF Rebellion and the Second Incursion, and then a fleet commander during the hypothetical post-Capella wars and/or Third Incursion.
Eventually, the GTVA reunites with Sol, and either the now older (or even elderly) MC gets a nice, happy ending by reuniting with their family, or a bittersweet one that sees them not being able to fully reconnect with said family due to decades of separation. The MC and their surviving friends have to come to terms with very real alienation, as they are now welcome strangers (but strangers nonetheless) in their own homeland. To drive this home, I might have a FOURTH Incursion occur which emphasizes the different mindsets of both parties to the Shivan problem.
Or maybe for maximum pathos/drama, I'd have an Inferno/BP-esque war breakout between Sol and the colonies, forcing the MC to lead a GTVA fleet in conquest of their own people. I thought about even having the position of "main rival" awarded to one of the MC's siblings, but that seems a little too melodramatic even for this campaign.
I dunno though, it's probably well beyond my ability to craft this without messing the pacing of a multi-decade tale up, or making it all too contrived. Amongst other issues.
Still, I can DREEEAAAM!