Yeah, the story's often pretty weird. I mainly enjoyed SG1 for the random episodes where they encounter and alien race/device and it follows the format of.
All is good, another mission completed, 'oh no we brought something evil back', 'oh yay we figured out how to fix it', 'oh fuck now we've got to fix it in time' and then they fix it and O'neil makes an unoriginal one liner. Credits roll.