I gotta go with the Talyn one myself. I grew up with Star Trek the original series but, by the time of the events of ST:III, the Enterprise was a shell of her former self anyway and I honestly was not all that surprised by it. The Talyn....Starburst thing was completely unexpected. Up until he actually did it I still felt Crais would not do it or they would find another way. Then seeing the look on Aeryn's face, knowing she was the one who had named him and she had named him in memory of her father. The look on Chiana's face, as she was the midwife basically, and then knowing that Moya would be heartbroken as she was his mother, and in turn Pilot was kinda like a father. It brought me to tears, which none of the others did.
I'm gonna have to YouTube this, I've only ever seen a couple of Farscapes and didn't like it.