My favorite campaign of all-time is still Derelict - I was playing it from the start, when it was just individual missions with voice-acting packs (Which is why my one has voice acting

The final version didn't have any :cries: )
My main gripe with Derelict is that it was a little buggy, but I didn't hit any major show-stoppers.
Homesick was almost perfect - It just needed Derelict's voice actors and it would be

(The voice actors for Derelict were superb!

)
Homesick feels a lot like Derelict in that it has a lot of flavour-text. This is what I liked a lot about both Derelic and Homesick - The game world felt more 'alive', and the AI pilots had a lot more personality, it wasn't just shooting crap up with some faceless wingmen.
Those are the 2 best ones, but I've played a lot more besides. I can't remember all of them since I played most of them a long time ago. They included stuff like:
Aeos Affair, Vortex, the Titan Rebellion, The Special Operations Command, The Regulus campaign, LDK, Inner Troubles part 1, Enemies United and Beyond the cause.
A lot of campaigns, ranging from from pretty cool to ridiculously hard through to downright silly

, but were all quite fun to play

Lessee... what else...
Ahh, the B5 mini-capmaigns, they were all pretty fun (But hard!! Bloody shockwave deaths got me so many times!!!)
And the BWO teaser, that was pretty good. The voice-acting wasn't as good as Derelict's but it definitely adds a lot to the campaign.
The Lightning Marshals wasn't bad, but I haven't played most of the recent ones since I am boycotting FilePlanet, and that's the only place you can get all the files...
This is a bit cheating, but my final favorite campaign is the multiplayer mod for the FS2 campaign. Play it on the hardest difficulty with 4 friends, great stuff

("Cover me you arseholes!" ; "Cover yourself, I've got 6 bloody dragons chasing me!" ; "HEEELP!" ; "Don't worry guys, I'm 2 seconds away from dropping my Heli-WTF?!" ; "Damnit man, why did you fly in front of my Trees!?" ; "I *%&%$& HATE you!!!"

)