How about the bit in the Shawshank Redemption where it slowly dawns on the Warden - just how totally screwed he has been?
I like the ones where justice finally prevails and the bad ones get what they deserve - it only seems to happen in the movies...........