Yes, you are correct sir in assuming SGU was indeed my first venture into the Stargate Universe. Well... that's not entirely true. I did see the movie some umpteen years ago, but never watched a single episode of the television series. By the time I got around to wanting to watch it, it was so already established that I thought it may be hard to jump in midway through. So when I saw a brand new Stargate series being created I jumped at the chance to start from the beginning. I was hooked, although as my friends who liked the original would say it was terrible, I having no prior knowledge of the show found it quite enjoyable.
Long time ago I used to watch Torchwood, season 1 and 2, but I haven't kept up with that one much after season 2. These are pretty much the only shows I've seen in the past few years, I'm quite happy with them. I just got into Walking Dead when it came out because everyone was talking about it and was presently surprised how quickly it sucked me in. Also, there's a very funny/not so funny story involving me, my wife, sleeping, rolling over, moaning and me waking up half dazed thinking I was being attacked by a zombie, fill in the blanks from there.
My first experience with Stargate was like you in the original movie, I think 16 or so years ago probably more. There was a Stargate super nintendo game, that definitely tells its age.
I do highly recommend, whenever you get to chance, watching Stargate SG-1. There are 10 seasons and 2 after season ten movies. I believe in episode numbers it is at least 215 episodes, somewhere around there. I have all but season 10 on DVD, just never got around to buying it.
Stargate Atlantis ran for 5 seasons, 2 or 3 of which when SG-1 was still running. It gets more in depth with the ancients that built the stargates.
When you watch these two shows, you will realize just how little amount of storytelling that SGU does. It would be way better if it gave relationship angles a rest and actually got to some storytelling about the real subject of the show. I don't know, to me it feels that all this relationship stuff feels like stall for the writers, because they've written themselves into such an epic story that they don't know how to actually write it. They come up with half an idea about the ship or the stargate and then layer a bunch of soap opera-like relationship stuff to try and fill the other 30 to 35 minutes of a 42 or so minute show.
On Torchwood, it didn't go for much longer after season two, just the 5 part mini series Children of Earth, and that was it.
Torchwood was good, but it was just Russell T. riding of the coattails of Doctor Who with a spin off.
Russell wasn't very caring about Doctor Who anyway. I think he purposefully wrote Torchwood into Doctor Who canon because he had already planned a spin off show to try an ride on Doctor Who's success.
The man is a moron if you ask me, and pretty much every Doctor Who fan. He actually stated something to the affect about Doctor Who, "Screw canon, I can write my own canon." He's also the idiot that wanted to make a Doctor Who movie here in America, but it was going to be totally against canon, because it wasn't going to involve any current Doctors. He wanted to cast Johnny Depp as the Doctor. He said that he wanted to make something that reached people other than fans, which is his way of saying, "Screw you fans, I can do what I want even if it will screw up the image of the show and make people new to it confused."
Here is the article on the Escapist about it.
I haven't heard much about it lately, I'm hoping it fell through, or it was just Russell T. trying to make waves to make fans made, which he loves to do.