I don't remember the last thing that actually made me cry, so I'll go with the last things that made me choke up.

The Prince's Tale part of Deathly Hallows Part 2. Especially Snape holding the deceased Lily's body.

And an episode of Star Trek: Voyager I rewatched recently, "Real Life" . The ending gets me every time.