How would this be for a plot twist: SG-1 finds the holy grail, but all it is is gate coordinates to ANOTHER planet where the weapon actually is, and they try to dial it but it turns out that Rodney stole the gate to use in his bridge, so they send the Odyssey which in turn gets blown up by an Ori ship on the way, so they have to join forces with Adria, Ba'al, and some replicators and steal a Wraith hive ship to get to the planet, but then there is a rogue team of Genii hiding on board who are working for some of the Goa'uld that have infiltrated the Trust on Earth, and... you know I have no idea where I'm going with this.
Oh and it'll have invisible Jack.