Television

So. SG-1 was supposed to end after season 8 (hence Moebius). They were planning a new spinhoff series called Stargate Command to replace SG-1, when SciFi got notice from the parent company - I think at the time it was owned by USA Network? - that they needed to drastically cut costs, and the only way they could lose the amount needed was to cancel a series.

Bonnie Hammer, who was president of SciFi at the time the decision had to be made, was a massive fan of Farscape; she wanted to cancel Stargate Command and keep Farscape running. Only there was a bunch of concern that Farscape didn't have the ratings the network would need, and more concern about launching yet another Stargate spinoff - Stargate Atlantis had just launched in 2004 when the decisions were being made, and Stargate Infinity had failed miserably a couple years earlier.

Despite the struggles, they decided that Stargate had more name recognition and staying power than Farscape, and Hammer made the painful decision to cancel Farscape; and also cancel Stargate Command as a spin-off but instead to role it's concepts into a continuing SG-1. With RDA having left, they had cast openings, and Hammer brought both Browser and Black from Farscape over to the revived SG-1 (hoping to also bring in song Farscape fans to boost SG-1's ratings), where it lasted out the contracted two years.

Atlantis ran for another couple years, until Cooper and Wright decided they really wanted to clone the darker themes from Battlestar Galactica and created Universe. But they didn't prep the audiences correctly. A lot of the OG SG-1/SGA fans didn't like the new, darker atmosphere, and a lot of potential fans who would've liked the new series never tuned in because the original series hadn't captivated them. It was on the verge of finding it's audience but time ran out; Universe only lasted two years before it too was cancelled.