I did comment on arc as well, albeit I focused most of post on the comedic style so my points about the arc might have gotten lost.
Take the last 3 series of DS9, very few of them can be watched without understanding the context of the wider arc. SG1 went a little this way with the last two series too but the Ori arc was quite a departure from the rest of the show (even to the extent of having different leading staff).
The Ori arc does get a little darker (albeit not significantly so), introduces more space battles (now that Earth has spaceships of their own) and really brings the “battle of the gods” plot to the forefront (like DS9s Prophets vs Pah-wraiths) so there’s definitely a lot of crossover between the two franchises there.
But I feel the real genius in SG1 was its main arc that preceded the Ori; which is also the significant body of the shows work too.