Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Galaxy Quest
Qualek's death always starts the waterworks. This innocent alien fan boy gets abruptly shot just after helping his idol save his crew, and has a few last words with him that should be narmful, but most certainly are not.
Jason explaining the true nature of Earth television and fiction to the naive Mathezar. It's like watching a slow, hard breakdown of a child discovering that there's no such thing as Santa.