Memento: ... It was kind of cool watching them dig out the stargate.
As I recall, that scene had a great soundtrack and some excellent camera work, worthy of a feature film. The president's speech was superb.
was a great episode on all levels, even O'Neill's needling of Herat. "Failing upward I see," and "Tell your boss you screwed up again," were some of my favorites.