Angel Beats had it's share of sad moments, haven't watched Clannad yet but I've heard it's the top
dog for emotional stuff.
Surprisingly the death if Minene in Mirai Nikki was pretty sad, she's my favorite character in the series.
And from the more recent stuff, the first 10 minutes of Kotoura San were extremely emotional.