Lorne's Embarrassing Moment, I think, will always be losing his lunch in front of Teal'c on his first off-world mission, back when he was a clean-cut, sweet little geologist.