I honestly stopped watching SG1 a while back, (Still love the earlier ones mind you ) I watched the latest seasons and felt pretty disappointed, especially by the Ori storyline.
For me, it should have ended at the end of Season 8 (That two parter was one of my favourites)