Oh, sweet mercy, yes (cue crying self to sleep while hugging pillow). Heck, it seems like every other episode of the entire series is alternate CrowningMomentOfHeartwarming and "Crowning Moment Of Heartbreaking", sometimes (like the scene mentioned above), both at once.
The second to the last episode of Kanon 2006. Especially if you've never read any of the manga, visual novels, or seen the first series, like I did.
Even the often-maligned 2002 anime series hits most of the right tearjerker notes, including the Makoto arc, the opening narrations (especially in retrospect or rewatches), and Yuuichi learning the truth about Ayu's past. Particularly touching in all incarnations is Ayu's wish, "I want you to forget about me."
