I liked Star Gate with Richard Dean Anderson (of McGyver fame), but not the later ones not so much.
I liked Stargate Atlantis. Lots of space battles and techno wonk exploring the city.