The anime Clannad and its sequel, After Story. Plenty of scenes that will make you cry big, wet, manly tears.
The first scene that ever made me cry was when Fuko, a little girl in a coma that only wants people to come to her sister's wedding starts to fade away. People can see her spirit wandering around at her school and people begin to forget about her. Eventually they all do but the main character still remembers on the inside. In the end everyone remembers and Fuuko's sister manages to see her spirit at her wedding before Fuuko slips back into her coma. Beautiful music playing at the time. I get teary eyed just thinking about it.