I've got a couple that might fit the bill... all of these involve character death and are mostly slash.

Sight (RDJ verse)
Shattered (ACD verse)
Consumed (ACD)
Repercussions (RDJ)
Whimper (ACD)

Others of mine that are generally angsty though perhaps not enough to make one cry. ;)
Abysm (ACD)
Confession (ACD)
Unforgiven (ACD, also character death)
Melancholia (ACD)

Fics by other people:

Alone On The Water (BBC, guaranteed tear-jerker)
His Last Bow (BBC)
there we'll find peace (categorized as RDJ, but can read as ACD) --the author of this has some other good fics