Second Great War
I'm sorry.

Everyone seems to forget The Titan Rebellion. It's an excellent campaign with a lot of originality, and nearly as many cool moments as Derelict. It's also very well-balanced and thought out.
Anyway, you should try adding Sync and Transcend to that list, when you get FSO installed again. Just Another Day could really add to your experience as well.
If you can wait another month or two as well, there should be two new campaigns/mini-campaigns available, including GTI Rebellion Chapter 1 and the Pathways demo (which, I can assure you, will be excellent), all of them for retail.
If you want to laugh at sheer idiocy, download Escort Duty or Milennium. Horrible FREDing + equally horrible dialogue = Funny as hell.