Maybe we'll get a direct-to-DVD movie to wrap things up...but I'm not holding my breath.
Unlikely. As was mentioned above, the SG-1 and SGA movies have been canceled. This was due, apparently, more to the rising cost of productions in Canada than anything else. After the show's off the air, I doubt SyFy has much to do with it. At that point, I think, it's an MGM property. But nobody wants to spend the money on these franchises.
SG-1 I think is basically cleanly finished at this point. It wrapped up the Baal storyline and the Ori storyline, so anything else is just gravy. SGA, I gather, ended with a lot of stuff unresolved, as did SGU, I'm guessing. I never watched either show (although both are available on Netflix in their entirety). What I find goofy is (A) the insistence on pushing things to the last second and hoping for a "wrap-up" movie rather than using your existing budget to wrap the show up on the air and THEN do your direct-to-market standalone films.
They majorly shot themselves in the foot with this. Take a look at their facebook page. Hundreds of fans in the last few hours have unliked them, and announced they are cancelling their subscriptions and boycotting the network.
You can't molest your fan base like this and expect to make money. They are fools, and will get what is coming to them. I can't wait for comic-con. It's gonna be a beatdown of epic proportions when Bonnie Hammer and everyone show up to pimp their new wrestling and reality shows to be greeted by a mass of p'd off stargate fans! I hope they disrupt every panel, the floor, everything.
I expect this type of crap from Fox. But Sci-Fi? It's like your mother punching you in the face and then asking for a hug. What the frak!
As for the show? Was a great season finale.
Horrible Series finale. Simply because it was never intended to be an ending.
This seriously makes me more and more angry every minute. And it's got barely anything to do with SGU, or Caprica. Just symptoms of the disease.
Not to disrespect SG* fans, but honestly, I doubt that SyFy is going to give a crap about what they think or how many (or how few) protest their actions. This is a lot like the "Browncoats" movement where there's a feeling of solidarity among the fan community, but it doesn't have the critical mass to accomplish a whole hell of a lot, and even if it did, the people holding both the rights and the purse-strings aren't listening.
Honestly, hundreds of fans "unliking" SyFy's facebook page isn't going to mean a whole lot, and I REALLY doubt people are going to cancel their ENTIRE cable subscription just to make a point about Stargate TV shows (seeing as how SyFy is usually part of a bundle rather than a standalone channel like HBO).
As I've mentioned elsewhere, I think that SyFy's new (well, maybe not so new) business model is all about profit margins. They want to put the least money into a product to squeeze the most money out of it. This is why they cancel expensive shows like the Stargate shows, shows that have run for more than, oh, three or four seasons like SGA and BSG, and spend their money on stuff like stupid (but cheap) reality shows, and movies that even Roger Corman would say "Whoa....that SUCKED" like Giant Bumblebee vs. Manticore. I'd bet wrestling is the most expensive single show in their lineup or, at least, that's the eventual goal.
Towards that end, ratings only sort of matter. It's like an entire network of nothing but non-stop daytime TV. You don't EXPECT high numbers, but you're making money by selling discounted ad space for shows that cost a pittance to produce.