There are still missions and campaigns (plus other goodies) available at
http://subguru.com/ .
Subguru is from the pre-RA days, you'll still want to check if the missions and campaigns were built for the stock game or LWAMI, but there isn't a huge difference.