My FIL was into it pretty deep, so I saw a lot of it back when we only had one TV.
I think we still have it on DVD, tucked away somewhere. I always love how dry RDA was when he delivered his dialogue.
Also, I love the symmetry of Stargate Atlantis launching Jason Momoa's career, and then how he went on to play Aquaman...
I remember vividly rewatching the original Stargate movie shortly before the the TV show was to premier on Showtime. I remember thinking "I don't understand how they're going to make this a whole season... the story is complete!"