Not to take a away anything that SG-1 meant to so many people, but I personally would rank other series a bit higher. Back then I was not that much of a fan for these kind of comedic elements in SciFi. But I thoroughly enjoyed The Orville last year. Maybe I give SG-1 a spin.

Can you recommend other SciFi series from back in the day?

Babylon5 has the best story arc on the macro and micro level from my personal opinion.

There were also other series like "Space - above and beyond" or "Dark Skies" that only got a single season despite incredible potential to paint a really deep and unique universe.

I stumbled over Gene Roddenberry's "Earth - Final conflict" and am inclined to binch it.