Most of the Bloodborne NPCs come to mind since it’s a very tragic game overall. Millicent’s in Elden Ring is pretty sad too. The Divine Child of the Rejuvenating Waters in Sekiro has an emotional impact on me too - very cool ending associated with her too
The pyromancer guy in ds1 was very kind and helpful. I don’t want him to go hollow :(