I think the new Stargate movie, Continuum, rocks. This movie explores Cameron Mitchell's past when time is altered by the return of a familiar Goa'uld. This movie became available on Itunes on July 28th. This will supposedly wrap up the Sg-1 storyline with the downfall of the goa'uld but fans everywhere (including me) can't hope for more.

Here is a youtube trailer that has a silly little skit with Daniel Jackson in it, everyone's favourite archaeologist. Funny in and of itself.
http://stargate.mgm.com/specialops/link.php?link=9&id=5821

Any fellow stargate fan is gonna love this site I just found. It is full of behind the scenes videos. Makes me feel so warm inside, like a kid in a candy store. They have interviews with actors, directors, backstage footage, and videos from their trip to the icy north.

Here is the link
http://stargate.mgm.com/specialops/link.php?urlid=1&id=5821

Official stargate special ops member