I saw your post in general. I can relate.
There are a few good campaigns comming down the pipe. Herr Burt is laying the groundwork for his Day of the Eagle campaign (R vs F&G '73-'77), and Skull&Bonez is nearing ready for his Return of Doctor Strangelove campaign (a merged shipslist campaign featuring 2 player teams; the Alliance vs. the Coalition, with the Admins playing a 3rd superpower race). I think the last piece to fall in place there, will be the change of venue for the SFC2.net team, from BBJs care to XCs (SFC2 is still runnning the show, but XC has graciously offered to host).
As far as I know, there are no major campaigns running at the moment, but TracyG, DarkElf, & Rajnsaj are actively working to get a fully functional SQL campaign going. I'm sure they're looking for help from dedicated testeers. It looks like they may be doing mission driven database changes before long (dool).