Possibly The Brotherhood. It sets up a lot about the characters, puts them all in their roles, has some Genii action, and also introduces the concept of "fucked no matter where you stand" - a concept Team Sheppard is intimately familiar with.