SG-1 is getting pretty stale
SG-1 has been stale for a couple seasons now. They jumped the shark with Daniel dying and coming back. It really, really needs to go away now.
Atlantis will probably last around 3 or 4 seasons
Dunno. Right now they're relying on people to watch SG-1, then Atlantis, then BS:G... as long as people do they'll keep it. I've stopped watching it though -- as painful as SG-1 was to watch, Atlantis was only moreso.
I miss Showtime's SciFi shows
Yeah. When they sold SG-1 to SciFi I dumped my subscription. They had some good stuff for awhile though.
And I agree that SciFi appears to mostly produce drek. They've occasionally done well (BS:G for instance, the Dune mini-series), but most of it is B-grade crap at best.