I'm also man enough to admit that one scene in Transformers: the movie can get me.
It begins with Prime gazing across a battle-scarred Autobot city, bodies lay unceremoniesly strew everywhere.
"Megatron must be stopped. No matter the cost"
He transforms, and an incredibly moving song plays in the background (The Touch) Eventually he comes across Megatron himself (After going through the Decepticon ranks, filled with passionate fury) They proceed to kick the crap out of eachother.
"I would have waited an eternity for this. It's over prime"
"...
Never!"
The Decepticons retreat, and the Autobots consolidate their "victory"
We jump to the Decepticons aboard Astrotrain.
Megatron is dumped from the ship without a second thought.
Optimus Prime has his soliders around him unto his last moments, he gives one final speach, and passes on.
The world goes silent as my childhood hero dies from the wounds caused by a terrible fight between him and his nemesis.
Also the episode "Dark awakening" gets me.
Optimus prime has mysteriously returned, he lives! But, somthing is amiss..
Somhow, the Quintessons have breathed life back into him, and are using him in some nefarious scheme to destroy the Autobots.
As Prime himself realises this, he orders the Autobots to retreat, many have fallen this day, and Prime takes it to heart.
He drives the Decimated Autobot mothership straight into the quintesson lines, destroying himself, and the Quintesson weapon arrays with him.
And for the "last" time. Optimus Prime did leave us.
Dinobots death in beast wars is terribly moving too, but not quite tear jerking.
Dinobots death scene, probably means nothing unless you know whats going on mind
I hope you atleast understand why these moments are so saddening to me, even if they dont conjure those feelings to you.