Big fan of the show. My wife and I do a rewatch almost yearly.
I'm not a fan of the film; it just struck me as silly, failing to explain the less than believable cultural situation. The show makes it work.
Atlantis is good as well, though I think the Wraith are a nonsensical race (the later, in show explanation of their origins helps, but not all that much).
Never saw SG-Universe, having read too many negative reviews.
One of the great things about SG-1 was how they built an over-arching plot with a lot of depth to it, and managed also to have some solid physics elements included— the episode with the black hole is exceptionally clever on that front. Of course there's a lot of handwavium and non-existent "elements" too, but that's just the set-up.
And yes, O'Neill's* dry one-liners are a highlight of the show, especially when he's mocking the various ridiculous premises they confront.
*"Two ‘L's."
And T'ealc serves as a great straight man. Christopher Judge is under-rated as an actor; he nails the character.
I think maybe some people are put off by the first few episodes, which after the pilot seem a little mundane: SG-1 travels to another world that looks like Canada, meets the descendants of ancient humans there, and mucks around with the "problems" with those ancient cultures. A bit yawn.
But then episode 6 "Cold Lazarus" is reached, takes the drama and characterization up several notches, then two episodes later we learn of the Asgard, and the show takes off running.