I have just finished watching the entirety of Stargate SG-1.
It's got issues, but it's main story arc blunders along nicely to wrap up with a very satisfying conclusion. And then it carried on for two more seasons and just abruptly ended. Do I watch the TV movies that finish off the story with the incredibly boring Ori?
I think SG1 is a great test of ones ability to suspend disbelief. It is so utterly ridiculous. Almost everything. Start to finish. Idiotic. Not great sci-fi, barely any good ideas done well, a real problem with escalating the stakes, deus ex machinas every other episode etc. etc. Still, I had a blast watching it. It is irreverent and silly and mostly fails when it tries to be serious. It's best when it uses meta humour and there are times it's clear it's self aware enough.
Nevertheless, when they try and go serious they make bad decisions, one of which led to a character being written out for a cheap "we want to show the stakes are real" death. It's really bad, it's really dumb, it's really unnecessary and I feel sorry for the actress who essentially got fired for it to happen. They thought they weren't being cheap by doing it and it does make me question how self-aware they were of the show.
They also seem to resent their audience as there are numerous digs at sci-fi fans throughout.
I could go on. This show has so many terribly quirks. It's a train wreck. But it's a fun train wreck. That metaphor doesn't quite work. I wouldn't recommend any watch this show and I understand why any given person would hate it.