Stargate is... its own thing, but if you like it then Stargate Atlantis is good.
Personally, I never felt like any of it was ever as good as even mediocre Trek, and it definitely has this military fetishism / combat focus that I didn't care for as much, but there are some pretty good and fun episodes as well and there's a ton of Trek/90s scifi alums you'll recognize (including Connor Trinneer playing a big bad that is definitely not Trip Tucker).
I agree with this. Maybe this is a consequence of binge watching SG1/SGA over the course of 3-4 months, but their episodes ended up feeling very repetitive, formulaic, and too often leaned on Carter/Rodney being super geniuses to get them out of trouble. SGU was a much needed shake up and, even though it did get too soap opera drama sometimes, I appreciated that it kept that BSG back-to-the-wall energy up from episode to episode. It may not be as good as SG1/SGA, but it never dragged like those shows did mid-season.