Key visual novels are notorious for this. I think Little Busters! had me crying for the majority of Refrain. CLANNAD and Tomoyo After also have pretty tearjerking moments. And it hasn't gotten aaaany lighter on rereads.

Besides Key, there's G-senjou no Maou which hits you out of smurfing nowhere with some of the heaviest emotional jackhammers I've ever been hit by.

And then of course there's Umineko... which isn't really a tearjerker at all but I've gotten so damn attached to it that every scene where (SPOILER)lol I'm not gonna spoil Umineko are you crazy brings me to tears.