Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Syberia
Syberia II: whenOscar does what he was created for and sacrifices himself for his creator. That was especially heart-wrenching, because you had to start the transformation process and he wasn't happy about what he has to do.
YMMV, but the ending of Syberia 2 may be very much this. Hans, an old, old man with the soul of a young child, finally achieving his dream of riding a mammoth... The scene is extremely dreamlike and ambiguous. One common interpretation is that it's actually symbolic of Hans' death and the mammoths are taking him to heaven... Not a single bit less tearjerking.