Not That Good... But By Today's Low Standards of SF it's Great!
In the 70s, science fiction films were pretty good, they had real stories to tell, be it Rollerball, Planet of the Apes or Soylent Green. The one thing they were missing was decent special effects. That all changed in 1977 with the release of both Close Encounters of the Third Kind, and Star Wars. Then, for a time there was a new golden age of science fiction. Films with both good writing, and good special effects: the Alien series, the Back to the Future series, The Thing, E.T., the Terminator series, Blade Runner, etc. etc.
But the message Hollywood took away was "special effects sells". So by the 90s, we had films that were more style than substance - a trend that continued, with the films degenerating with each Matrix sequel released, until by the 2000s SF films are little more than nonsensical action fantasies with a bunch of digital effects in them. Sadly, one of the films that started us down this sorry course was Stargate.
But by today's low-bar standards, Stargate actually looks semi-decent. Oh, it's still a film with more holes in it than a block of Swiss cheese (I dare you to try to summarize the plot). But, as long as you don't ask any questions like, 'Where did this alien come from?', 'How is it you can pick up an alien zapper thing with no trigger and shoot it with no problem when you can't even hold a human pistol straight?', or 'How come these guys drink the water on an alien planet when I won't even drink the water in Mexico?' you'll be fine. Just sit back and enjoy the ride.
I'm also pretty skeptical when any film bases itself around pseudo-archaeology like Erich VonDaniken's 'Charriot of the Gods' type crap ( Indiana Jones and the Kingdom of the Crystal Skull, I'm looking in your direction). But again, the charm of James Spader and Kurt Russel in the equivalent of a ' Buddy Cop' film in space, can help overcome a lot.
Turn off your brain - watch it for the set pieces and effects, the occasional humor; marvel at how this B-movie sci-fi film of nearly 20 years ago is still light years ahead of most so-called A-movie sci-fi films of today, and you might actually enjoy it.