The original old show? It’s meh okay 70’s sci-fi TV. Not into the kid and his robot dog or whatever.
The 2000s remake? It’s basically what cured my television habit. I was never really into the “gritty realistic” heartburn drama shit anyway, so I gave up on the show itself pretty early, then spent the rest of my time as an SG-1 fan having Katee Sackhoff scream in anguish at me during every single commercial break for years on end. Then every TV show made from then on had to be a dark and brooding show about terrible people being terrible to each other and then I stopped watching TV.