1. Elite Dangerous - PC
2. Soldier of Fortune - PC
3. Star Wars: TIE Fighter: Defender of the Empire - PC
4. Star Wars: TIE Fighter: Enemies of the Empire - PC
5. Star Wars: X-Wing vs. TIE Fighter: Balance of Power - PC
XvT came out a few years after TIE Fighter and gave us a multiplayer game where people could finally pit the ships of the Empire against those of the Rebellion in a human vs. human setting, rather than against the CPU with tall odds. Unfortunately, the game took a lot of flak for being pretty much exclusively multiplayer focused; while you could do all the content solo with AI partners it was all based around stand alone missions with no storyline. And all the non-training missions were balanced for teams of humans on each side. Balance of Power is the expansion that seeks to rectify the complaints a bit, and ends up succeeding about halfway.
Balance of Power provides two campaigns that have a running storyline to them which operate in tandem; each tells the story of the ongoing conflict in a particular region of space between the two powers, and you need to play both to see the full story. The final mission for both is somewhat shared; the missions do not have an identical setup, but they are depicting the same battle. So all the missions but the last one definitely happen as described, and the last mission is likely mutual destruction. The campaigns feature both ship progression (you start off in inferior ships compared to the ones you finish the campaign with) and multiple roles in most missions; typically you'll have some pilots on fighter sweeping duty while others will be managing the capital ships. The missions can be a bit samey, as they tend to have the same progression of "there's some interceptors and some heavy attack craft, you need to balance how you attack them". But there's only so many ways you can spice up space battles, especially when there can be up to eight human players working together, so you can't just have one person be the hero.
Unfortunately, the fact it still is built for multiplayer causes some major rough edges. The first is the dramatic difference in difficulty settings; on medium and above you cannot take out capital ship hardpoints until the shields are down (at which point it is far less necessary). This is an obvious balance mechanism due to how easily a full team of 4-8 humans could pull the teeth out of a capital ship and then just take it out with lasers, but as a result when you're flying alone it makes the ships far more of a pain than in previous games in the series. There's also a handful of missions where the AI being reactive really puts things up to luck. With humans you can pre-place yourselves for an incoming wave, but with the AI they're going to do their thing. And a couple of missions based around inspecting craft are timed, and since the AI doesn't inspect you have to frantically race and hope the AI can keep enemy fighters off you. This leads to a handful of missions being far harder than they should be, including the penultimate missions for each campaign, which are an exercise in how much bullshit you can put up with until you get that one lucky run where things go your way. By comparison the final missions are much more manageable, though the Rebel finale as a bit more luck involved than the Imperial one (which is basically won with overwhelming firepower).
One good thing that can be said is that there is a bit of puzzle solving in figuring out which role you want to take; you can only directly command half the fighters based on which role you pick, so sometimes you might want to take a slower ship to ensure correct target prioritization. Taking out a ship early can stop enemy fighter waves, which can be incredibly important to give you more room to play with when defending a target. And the engine improvements make the game much prettier (though dogfighting is harder due to the hitboxes being tightened up and beam weapons being nerfed for competitive balance).
Frankly, the whole thing is basically skippable if you're not going to do it with friends; the storyline isn't really interesting and there's no particularly clever missions, so it's mostly more dogfighting with the occasional joystick snapping frustration.