I'm a bit new to the VN scene, but I just finished up Hoshizora no Memoria, and I have to admit that every ending made me cry. Before that ShiniKiss had also made me cry. While Hoshizora made me shed the most tears, ShiniKiss definitely made me cry the hardest with the third heroines ending.