SG-1 is ok, but I wouldn't say it, or any of the other Stargate series are better than ST, but that are far superior to Star Wars. I haven't finished SG-1 (i am a fan, though), as I no longer had time to keep up with it around when the new bad guys came in, and have never got back around to it since then. Although it wasn't very original, seeming to borrow heavily from the BSG reboot and Star Trek: Voyager, I wanted SGU to stick around longer. I caught Atlantis here and there, and will probably go back and watch them whenever I go finish SG-1. The original film is still one of my favorites. At present I watch Ancient Aliens whenever there is a new episode, or at least have it on as background noise, and I still enjoy the Lovecraft version of this sort of stuff, and read the stories by him and his friends.
I don't know if the Win would be the kind of thing they would use in Stargate. I like to imagine the Pyra might work out, even if it wasn't official equipment. More than likely they would use something a bit more mainstream (like a tablet or smartphone) or have something custom made for the military. The biggest weaknesses I see for handheld computers are durability and input, so the Win fails with those. There are other things that will also be important that would be better determined knowing how such a device would be used. Throw Wesley Crusher in there with MacGyver, and it didn't matter what you give them or what they encounter, they can fix it. Bah, I forgot about Samantha Carter, the Wesley of SG-1.