I've never watched the TV series--the previews looked rather stupid. But I'm sitting in this room in Bend, Oregon with not much to entertain me. The landlord is somewhat involved in the Central Oregon arts scene, and has a lot of friends in the movie business--and among the films sitting on the shelf, was Stargate.
This was better than I was expecting--quite a bit better than I was expecting. Once you accept the premise of a controllable Einstein-Rosen wormhole technology that allows movement across vast expanses of space, then the rest of it is pretty plausible science fiction--and a nice combination of action film, interesting ideas, and the human fight for dignity.