Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Johnny English
Johnny's scream of frustration after he accidentally breaks into the hospital. Despite his apparent confidence and smugness, you can see that he knows what a screw-up he is and is deeply ashamed of the fact.
In the second film, Johnny's death scene. Even Pegasus is sad.