I could see him being, ahem, 'encouraged' to work at Area 51 or the SGC. It's not far from there to meeting a certain pilot.

Exactly :o) I can't really see him on Atlantis - all of Rodney's talking about the other Sheppard, just seems like it would be too much pressure for the Sheppard they do have. SG1, on the other hand...