When Sha're died. Seeing Daniel not quite crying as he did through the episode just got me. MS and CJ were brilliant in that episode!
Also, when Janet died. It was so totally unexpected. I was in shock.
I also cried the whole way through the last half of S10 as I knew it was the end of my favorite show.