No it hasn't. At least not as a Stargate series.
Stargate was always about one thing.
Sucking as hard as possible with sophomoric humor and mediocre rehashed music? A solid B- sci fi show, sure, but really not that great.
Just because there aren't a lot of A level sci fi shows doesn't mean we should worship a mediocre one.