Stargate SG1 is definitely worth watching
eventually. By that I mean there are certainly quite a few filler episodes where the show tries to find or keep its voice. But even building from the first season there are seasonal arcs and they build to overarching storylines that play throughout the run of the show.
According to wiki, there are
ten seasons plus two movies. Stargate survived on two networks (first five seasons were on Showtime and the final five were on SciFi). It also had two spin off shows, Stargate Atlantis and Stargate Universe.
All in all, I have a positive opinion of the series even though it's not always great. Knowing you, you'll have problems while watching but nothing more difficult or problematic than with any Star Trek episode. (I do have one friend who refuses to watch Stargate because it supplanted Farscape.)
Now then. Farscape is something I have no reservations about recommending to anyone who likes science fiction shows. It definitely has its share of cheese and camp and maybe some missteps, the storyline and the characters are the real reason you're watching. I can't imagine you not liking this show as completely as the next fan.