By far the best implementation of this in any game I've seen is Alpha Centauri. Each Secret Project that a person completed when the played completed it would yield a unique and very immersive video. A secret project or wonder is a one of a kind building that can only be built once. If the budget is not there for the kinds of short clips in SMAC, then I'd advise considering writing some cool stories.
