The end of Okami did it for me, though that wasn't really sadness, just the sort of general heart-warmingness that the end of that game had in such profusion.
For a similar reason, i almost cried for Jill & Lethe's A-rank support conversation in Fire Emblem: Path of Radiance.
Monster Hunter: pissing me off since 2010.