Derelict
would be in the hall of fame, if not for three things:
1) Second loop, mission 3: What the crap is going on!? Yeah, you're under attack, by cloaked fighters, but you have no support because your friends die so quickly, so you're left with a choice of stopping the jamming and getting the plot moving, or protecting the ship.
It's ludicrous, and no explanation is given at all for half the events in the loop. Considering how long it takes for campaigns to be released, I'd rather know something now than wait four years for answers.
2) After the halfway point, no effort whatsoever was made to mess with the Team Loadout screen. You could get Terran Maras and Kaysers about half the time. Bah I say.
3) A good number of the Section 3 missions seemed rushed. Extremely so.
Despite this, Derelict has a lot of good moments ("Wake up sleepyhead!"), and would be in the hall of fame if these bugs were fixed. The level of civilian involvement (especially in the early missions) is something that I have yet to see emulated in any other campaigns save Homesick. Loop2-1 especially impressed me on this score -- even 20 minutes into the mission, transports are still coming and going. GTVA Navy vessels aren't the only things in space, people!

In the hall of fame for me would be:
- Warzone (A lot of good gameplay, despite the slight bias towards bombing missions. This was the campaign that taught me how to dogfight in a Boanerges with Maxim cannons.)
- Homesick (this actually inspired my current project, Heroes for Hire... this is THE campaign. Seriously.)
- Awakenings (Yeah, it's FS1, but who cares? I'm just waiting for the ported version... *pokes the FSPort team*)