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).