I am almost embarrassed to admit it, but sci-fi crossover stories have always been something of a guilty pleasure of mine. In recent years, however, my love for them has waned some, mostly due to my frustration and disgust with the fact that you can't hardly even mention the words "crossover story" anymore before someone tries to turn the whole discussion into one big, nasty, hate-filled "versus" debate. (Don't know what I'm talking about? Check out StarDestroyer.Net sometime.) Also, there just aren't that many really good crossover stories out there. Most of them are either little more than thinly veiled vs. propaganda in narrative form, or they are horribly cliché, poorly written fan wankery. And even of the ones that show potential, most are lacking in scope, scale or imagination. The key to a good crossover story, is that it needs to be a story WORTH telling. It needs to be a story with purpose, a story that presents both universes in the best possible light, a story that flows in a logical, well-thought-out way, and a story that brings something fresh and original to the table.
By the criteria that I have just laid out, some crossovers work better than others. Some shows lend themselves far more naturally to crossovers then do others. Stargate, unfortunately, is not one of those. Stargate's greatest strength, at least originally, was that it was grounded in the "real" world. It was not set "Long, long ago, in a galaxy far, far away" nor hundreds of years in the future; instead it was about people from the here and now, people who worked for the United States Air Force, lived in Colorado Springs, CO, who in their off hours would go home and throw back a few cold ones while watching The Simpsons (or perhaps another TV show like Star Trek or a movie like Star Wars). My point is, in the world of Stargate, Star Trek and Star Wars exist solely as works of fiction, and have been specifically mentioned numerous times as such. For me, this pretty much excludes any possibility of a believable Star Trek/Stargate crossover, except perhaps as a dream sequence. Maybe Jack could fall asleep on his couch while watching a TNG episode on TV, and then have a really weird dream where he and his team somehow meets up with the crew of the Enterprise. It’s a bit cliché, but it could work if written well.