McKay was a very good expansion on an existing character, DH really plays him well, and the episodes with his sister in, the chemistry with those pair is excellent...
Amazon should make all of the SG stuff available on Prime, and then, once they have seen how much call there is for it and how popular it is, then lets see what comes from that..
I would like to see an Atlantis arc or mini series where it goes back to Pegasus and we can start to expand on the 'Lost Ones' (never bought the whole Asgard dying thing), and perhaps see who out of the SGU cast would want to come back and maybe work out a way to do something with that as well, SG1, well, as much as it was the series to kick off the TV runs, I'm not sure where else they can go with it, there's always been talk of making the Stargate Program public knowledge, but not sure how much of a series that would actually make, the Goa'uld are pretty much done, Anubis, Replicators, how many other SG1 bad guys are there out and about still? At least with Atlantis the Wraith are still around and Universe still had something to go from...