Seems people are rating the season/series low in reviews because not all of it is on Amazon Prime (seems to be now) or some issues with episode order and that is very unfair to this amazing series if Amazon messed something up send them an email to report it so it can get fixed don't leave a 1 star review that hurts the series.
I grew up watching the series reruns and it seemed endless to me, because I could watch any episode and generally have no issue understanding what is happening. As long as you have seen the first few episodes and a couple select ones here and there that introduce characters or factions you can watch any of the episodes and not feel confused about who people are or what is happening and I think that is a strength to the series compared to something like Lost where you have to watch every episode to understand things especially with it being such a long-running show.
As for the series itself, It's very well done. The characters are unique and likable, the action is good, there is a surprising amount of comedy, while still having serious stories, the stories themselves are quite varied putting the characters in a variety of situations, and I think it is fairly realistic to what would happen if something like the Stargate actually existed. It isn't just about fighting aliens there is so much more covered by the series such as ethics, history, science, politics, and more.
Overall, it is a great series for any scifi fan and well worth watching all 10 seasons and the movies as well. The sequel series Stargate Atlantis (5 seasons) is also well done, though the main cast on that isn't quite as good as the SG-1 cast IMO. The sequel to that series Stargate Universe (2 Seasons) changes the storytelling style quite a bit and also ends on a cliffhanger as is wasn't renewed for a third season and the movie to end it was planned, but was never made. So if you decide to watch everything Stargate you have a total of 17 seasons and 3 movies (plus the mini web series that came out recently). It is a big time investment, but it is a great series and well worth the time investment plus short of Star Trek and maybe Star Wars I don't think there is another Scifi series that can compare to the amount of content.