Those kinds of stories are a testament to this game’s strengths.
Maybe we need some sort of spoiler warnings. 😀
My favourite story that I recall is an attempted raid at an alien base. I was getting my ass kicked, and I had to pull back and escape the mission.
However, while escaping I noticed (with a mind probe) that the commander of the base had snuck in the way of escape. I was able to stun the commander while escaping, and carry the body out. This made it possible to interrogate the commander for the location of the Martian base.
I sincerely hope I’m not making the story up.