Season 4 spoilers below
I think I've seen the first Stargate episode that I didn't really like. It's episode 5 from season 4, where they think Carter and O'Neill may be brainwashed assassins (za'tarcs). First of all, za'tarcs were never mentioned before, and all of a sudden it's a big issue. Second, they could have easily figured out who it was by searching everyone for that blue hand-weapon. It irks me when none of the characters come up with the blindingly-obvious solution just so they can get a plot out of it (also a common pet peeve I have with some of Rossini's operas).
And lastly, shortly after Carter and O'Neill admit they have feelings for each other, another character dies who could have been a stumbling block to their relationship. Altogether too neat, too contrived. I think the screen-writers must have been asleep when they wrote this one.
Oh well. Everyone's entitled to the occasional off-day.
_________________
Melkor and Ungoliant in need of some relationship counselling.