There are great things about most of the campaigns, though I haven't read 'Skandersvik' or 'Order of Prometheus'.
There are also faults with every one of them.
I honestly felt Drinax was Pirates of the Caribbean in SPAAAACE, but then I'm not a huge fan of Mongoose's Trojan Reach. There's a real'Buck Rogers'-ish feel to it for me.
Deepnight was 'epic with a capital E'... While it kind of ended with something of 'thump' instead of a 'bang' for me, it delivered on everything it promised and more. And hey, it wasn't 'baddies from the Core' right?
The Ancients is also seriously E for EPIC... but in this campaign the PCs become so powerful that it would be difficult for the ref to adjudicate the campaign. I mean, when you're squaring off toe-to-toe with Grandfather, getting into trouble with Naval Intelligence is just a traffic ticket...
The Traveller Adventure was the absolute perfect sandbox campaign for Traveller. The dangers were understandable and realistic, the rewards were reasonable but still worth working for, and the campaign shined a light on one of the backwaters of the Imperium.
Heavy handed hint: I would really like to see a campaign on 'The Traveller's Adventure's' scale in a subsector away from the Marches and maybe even outside of the Imperium. A subsector in Mendan Sector where the players deal with the Julian Protectorate, the Empire of Gashikan, and Vargr culture would be AWESOME.