These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
YMMV: Stargate
Adaptation Displacement: The series is more widely known to audiences than the film that inspired it, partly because the original cast got replaced in all subsequent entries.
Cliché Storm: Roger Ebert's review boiled every element of the movie to this, right down to the snare-drum "military" music as Daniel arrives at headquarters.
Special Effects Failure: Retroactive example from the Blu-ray edition. The picture quality is so much higher than when the movie was filmed that you can see the wires holding up the Death Gliders (especially during close-ups on the pilots.
Unfortunate Implications: The film's story takes a rather colonial tone to the depiction of the natives. Namely, they are primitive yokels, helplessly oppressed by the local authority until they are armed and led by the predominately white soldiers of a Western military power. Thankfully, the subsequent TV series moderated that tone considerably.
Given how he has them trained to use themselves as human shields for him and has his own little Child-Emperor theme going, it's likely it was a different horizon they were aiming for.
The novelization of the film says the kids are there just for such an occasion; if someone managed to get into position to take a shot at Ra, they'd be unlikely to shoot through kids.
You'd think so, but Ra in Egyptian mythology was supposed to be somewhat androgynous.
Jaye did come across as appropriately creepy.
Possible Fridge Brilliance: if you're a godlike alien with your pick of human bodies to take as a host, why wouldn't you choose the prettiest one you could get?
Oddly enough, Jaye Davidson initially rejected the role, basically daring the crew to offer him a million dollars to play Ra. They called his bluff.
He was great for the role, too. When you first see his face, he doesn't look like an Evil Overlord. His face is, as the novelization put it, 'the picture of innocence.' Which makes his evilness all the more effective, the devil behind a pretty face.
Visual Effects of Awesome: The first Kawoosh, when you had no idea it was coming, and in movie-sharp clarity, epsecially if you were watching on the big screen. In the shows, it's cool, but seen in the movie, for the first time ever? Breathtaking. Also, the way the masks retracted into themselves.
The trip through the portal itself is pretty spectacular in its own right.