The movie can be a little dated, and it has a fairly different tone from the sequel series. It's arguably not the greatest introduction to the franchise, but it does set the stage with the premise.
Once you get into the sg-1 series, it gets closer to the Deep Space 9 formula. Episodic, but there's long running story arcs for each season.
I liked it a lot because it was a more modern setting for the sci fi, which was a fun way to tell the story. Like Star Trek, it's very much the ensemble that makes it work well.
Some people didn't enjoy when there were cast changes, particularly Richard Dean Anderson's departure in season 9. He is certainly missed, but I thought they did a good job creating a similar tone without making a carbon copy of his character.
Atlantis was also quite good. Universe was a very strong tonal shift, and the transition wasn't easy for fans at the time, but I think the show benefits from binge watching. Sadly, it feels like just as it finds it's footing in season 2, it gets cancelled instead