Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Professor Layton and the Azran Legacy
Oh god, the entire ending.
Aurora's final plea to the Azran revives her companions and Bronev, but now having served her purpose, she fades away as Luke looks at her with tears streaming down his face.
Aurora's helplessness in general in that scene, as she has to watch as her best friends die in front of her. She couldn't even sacrifice herself in the stead of any of them, because she was physically barred from blocking the lights.
With her mission to Targent complete, Emmy leaves Layton, saying her thanks and even putting in a good word for Luke. She calmly walks to the door... and then turns around to give Layton one last hug.
Descole giving up his name to his younger brother, so that the younger could be Happily Adopted. Then there's the fact that the Laytons couldn't take the both of them.
Fridge Horror kicks in here: Descole claims he's going to be looked after another family in the village. Their name? Phibbs. As in fibs. He's lying, and more than likely grew up alone.
The fate of the Bronev family is one big damn tragedy in and of itself. Leon's research led him and his wife to be kidnapped by a then-smaller Targent, and after his wife Rachel died Leon became obsessed with unlocking the Azran legacy no matter the cost. His son Hershel later became his greatest adversary to take back what he lost, growing almost, if equally as obsessive as his father. Theodore, or Hershel Layton would have a happier time in Stansbury and London, though his new life wasn't exactlya basket of roses either.