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.
"Legacy", the episode where everyone is infected with an anti-Goa'uld device, but that's sort of secondary to Dr. Fraiser opening up her shirt (and revealing her bra) because she's infected and hot.
While being a tame TV series, SG-1 had actual nudity in the pilot episode "Children of the Gods", which was edited out in later airings but is retained in the DVD release. However, the scene is definitelynotsupposed to be sexy.
Anubis from seasons 5 through 8 is by far the most evil and dangerous of the Goa'uld System Lords. He was banished by the other Goa'uld for actions they considered unspeakable even by their evil standards. (This is a race of megalomaniacal Puppeteer Parasites who think nothing of torturing their dethroned rivals to death, then bringing them back to life and repeatedly doing it again.) He tricked Oma Desala, a wise higher-dimensional being, into helping him ascend so that he could become an immortal Energy Being, making sure to rub it into her face how she is unable to stop his evil acts. His subsequent plans after his return include repeatedly annihilating civilizations and replacing the Jaffa warriors with mindless super soldiers. After his stable form is destroyed, he starts possessing random people to hold him until their bodies completely decay after a few days. His ultimate plan before he finally got taken out was to wipe out all life in the galaxy with an Ancient super weapon — all of it, including his own race and his army — so he could use the Ancient knowledge he retained to recreate a galaxy's worth of races that would unquestionably worship him as a god.
The next Big Bad, Repli-Carter, betrays both Fifth and Carter in very short order, manipulating Carter into feeling sympathetic because Carter believes Fifth was cruel to Repli-Carter. She was merely using Carter's torture experience as grounds to manipulate her. Then, she killed Fifth, not out of vengeance or emotion, but to fuel her ambition to consume the galaxy. When the real Carter showed signs of sympathy, Repli-Carter coldly and calmly, with a strangely static and uncaring version of the mannerisms real Carter would use when comforting someone, told her that Fifth wasn't worth any empathy because he was weak. She then set about wiping out the Milky Way, with her army devouring God knows how many people, ships, and planets. Eventually, she captured and attempted to torture one of Carter's best friends. Despite claiming that the real Carter's emotions and memories weren't meaningless to her, and having 'given her word' that she wouldn't invade earth or kill Daniel Jackson, she promptly did both. So, in short: in the few months she existed she killed her fellow replicator and creator, Fifth; psychologically manipulated and tortured her human progenitor, Samantha Carter; committed galactic genocide; captured and killed one of her progenitor's very best friends and tried to conquer their home planet; and all this in the image of a beloved galactic heroine, with just a little more ambition and a little less sentiment.
The Goa'uld implicitly invoke this, since they would deliberately take the most beautiful humans they could find as hosts, often resulting in gorgeous men and women leading the evil legions beating on Earth's door.
Adria of the Ori, played by Morena Baccarin. Vala makes sure to lampshade how the Ori's (male) followers will probably increase when Adria is full-grown.
Fan-Preferred Couple: There is a segment of fandom who believes Major Carter would have wound up with just about any of the male leads, but her and Jack O'Neill is as close to an "official" pairing as there ever got to be.
Fashion-Victim Villain: Every Goa'uld overlord qualifies for this trope. Bad taste must be encoded in Goa'uld DNA along with Dr. Doom rhetoric.
Ba'al swings widely: from looking like he's wearing a bathrobe to leather longcoats...
There's also Lord Yu-huang Shang Ti, the Jade Emperor, who not only dresses like a Chinese emperor, but he actually was the first Chinese emperor, meaning he created this style.
"Funny Aneurysm" Moment: "2010", an alternate future episode set in that year that aired in 2001, had the characters toasting the memory of General Hammond and talking about how they missed him. His actor died in 2008. Made even worse because they even state that Hammond supposedly died of a massive heart-attack. The same reason is given in Daniel's dream in "Ultimate Power".
Gary Stu: To some fans, Cameron Mitchell. The writers may have tried too hard to make us like O'Neill's replacement. On the other hand, Cameron was beat up and shoved in the mud so often, and his own team didn't even seem to take him seriously so often, that a more realistic look at the man makes him seem like an Anti-Sue or perhaps even Parody Sue with the saving grace of meaningfully contributing to the team.
In "Thor's Hammer", an alien woman notes that Sam and Daniel are "a little short for gods." It is later revealed that her gods, the Asgard, are indeed very short.
In "Grace", Sam is alone, hallucinating and desperately trying to fix the damaged Prometheus, while "Twinkle Twinkle, Little Star" echoes eerily through the corridors. Maybe she's related to Isaac Clarke? Made even more amusing considering that the previous episode, "Evolution" dealt with an Ancient device found in South America that was capable of resurrecting the dead as mindless, homicidal maniacs.
The teaser to "200" ends with SG-1 telling Martin that the Wormhole X-Treme! movie needs to have an awesome opening title sequence. Martin tells them that the industry's moving towards just throwing the title up there as a splashscreen and then moving on. (After which, instead of the normal title sequence, all we get is the Stargate SG-1 logo and a few bars from the theme.) Guess what Stargate Universe did a few years later. This was actually in reference to the opening half of the previous season, which did exactly that before reverting to the intro sequence following a sizable Internet Backlash.
We knew the Goa'uld were bastards, but their plot in "Singularity" has an extra degree of pure dickisness. They turned a little girl into a living hyper-nuclear bomb, and they set everything up so that Stargate Command's efforts to help her activated the bomb! This was specifically Nirti's idea; she's consistently portrayed as one of the most hateful Goa'uld — the protagonists were even more willing to kill her than any of her brethren, even if it went against their immediate interest. More than that, the people of Hanka were later revealed to be a long-term project of Nirti's, to create a Hok-tar. She willingly shot herself in the foot and slowed her research by wiping out the people of that planet, simply for the chance to wipe out Stargate Command. Now that's a pretty strong bit of hatred!
In the episode "Icon", Sorren crosses this when he executes a random officer for cowardice (he was just suggesting retreat).
Newer Than They Think: The P90 is often identified with the Stargate series (with many viewers having mistaken it for a fictional weapon, due to its exotic appearance), but it did not show up until a third of the way through season 4.
Makepeace, which makes it all the more satisfying when he turns out to be The Mole.
To some fans, Vala was this for a long time.
The replacement for Janet Fraiser (Lexa Doig), looked to be turning into this, with shoehorned "related to the new General plotline". In the end, she pretty much faded away after being a major part of basically one episode, and then disappeared for good because she had to go on maternity leave.
Ironically applies in-universe, as everyone openly distrusts her due to the incident in "Upgrades". Jack in particular makes no secret of his loathing for Anise and repeatedly asks to speak to the host Freya, since he actually does like her.
Strawman Has a Point: The arms dealer in "Talion" raises a valid point when he talks about how, under the reign of the System Lords, the Jaffa were revered and privileged while ordinary Humans were slaves. When Teal'c confronts him about the attack at the Jaffa summit, he gives him a brief Reason You Suck Speech and finishes with a raised glass and an ironic toast: "I rejoice, rejoice, at seeing you kill each other."
Senator Kinsey, in the episode he's introduced in, raises a pretty good point in regards to the Stargate programme being a huge money-sink which introduces far too many risks (attracting the attention of hostile aliens, bringing through elements which could pose a threat to humanity itself, being the only known entry point for the Goa'uld to attack Earth, etc.) with little-to-no returns to speak of. He's eventually proven wrong of course, but it's hard not to agree with his views.
To expand: during the first season, the cast had a bad case of Failure Is the Only Option when it came it acquiring anything useful. Find a device that kills Goa'uld while leaving the host alive? Have to destroy it to save Teal'c. Find an alien database full of useful knowledge? It gets destroyed. Capture a spare Goa'uld human scientists can experiment on? Have to use it to save Teal'c again. Find a handy healing sarcophagus? Yep, destroyed.
Suspiciously Similar Song: The dance scene at Mitchell's reunion in "Bounty" has several. When he dances with his old flame it is a pretty blatant Suspiciously Similar Song version of "Can't Fight This Feeling" by REO Speedwagon.
They Changed It, Now It Sucks: The new wormhole effect from Season 8. Some felt that the new effect made wormhole travel seem like a relaxing jaunt, whereas the original was a terrifying rollercoaster that would make you want to check for clean underwear afterwards. Hell, the original effect used in the series actually screamed during transit!
What an Idiot: The Hazmat Team's Big Damn Heroes moment in "Morpheus" is somewhat ruined by the medical team leader repeatedly ignoring Carter's warnings not to let her sleep and her attempts to give them information about the parasite. Really, it was very lucky they actually figured out both what was wrong with the team and to derive a cure from the immune lizard Teal'c found, which they could have done faster if he had just stopped to listen! Made more foolish since the SGC had been contacted and alerted that the people of Vagonbrei mysteriously died in their sleep due to some kind of infection. Who would think letting them sleep would be a good thing?
In "Prometheus", the fact that a civilian camera crew was allowed into the titular ship without even a check of their equipment (where they were hiding their zats). Why a civilian crew was even allowed, as opposed to one appointed by the Air Force and/or the Pentagon also makes little sense.