Command and Conquer Tiberian Sun
Containing all of the maps submitted in the last Open Map Competition., it has a great variety of maps.
This is the continuation of the Cabal's Return. It continues the campaign, although this campaign can also be stand-alone.
Here's a well-made series of maps that picks up where the original Firestorm Campaign left off, at Cabal's defeat.