The original Stargate movie was great until they actually went through the Stargate. The archaeological aspect and discovery were fun. Then it just became another Clash of Clans movie.
SG-1 was just a great series, carrying over Daniel's brains and curiosity, and it was just a lot of fun that became more interesting as they introduced the more advanced cultures. Atlantis was the same way, just a fun show.
Universe wasn't as fun, and the first season really dragged on. But once they started getting into the science and discovery again, partway through the 2nd season, it became very watchable. Then suddenly stopped.