The stuck-in-the-Puddlejumper one is called Grace Under Pressure, and yes, such a McShep story :D

Well, the thing with SGA is that they're NOT trying to push any of the hetships. There isn't much scripted UST, not really. Elizabeth and John's relationship is lovely, but it's not sexualized in any way. Teyla and Ronon... I'd love to see them make pretty pretty babies, but mostly their relationship is big brother/little sister. John and Rodney on the other hand..... *grins*