I've definitely seen this kind of fic scenario (in lots of different fandoms) — it's not really a trope I particularly enjoy so I don't seek it out, but I am familiar with it and it's definitely idfic to a lot of people, given how popular it is across multiple fandoms. I had no idea that a) it had a specific name and b) it originated in SGA fandom!