It’s probably because SG1 brought with it a more modern mode of storytelling and production values which is familiar and past some threshold that star trek doesn’t meet until maybe the later parts of ds9 to an extent at best.