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