What helped me was going in with zero expectations. I watched as it aired but fell of. It was just not a Stargate.

So when I rewatched years later I told to myself I'm not watching a Stargate show - and with this simple trick, it became quite enjoyable. And in S2 I noticed that Stargate elements actually do peak through.

And come second half if S2 (which I didn't see back then) I realized it became a true Stargate show (though, granted - a bit more serious.and gritty - but with a genuine Stargate soul).

I was devastated that it ended once I reached the end.