Fans of the Dark Souls series are well aware of the tragic stories in FromSoftware's games — a sentiment that extends to other FromSoft titles like Bloodborne and Sekiro. Hidden behind obscure storytelling, ominous and vague dialogue, and item descriptions lie many tales that tell of heroes rising to confront great battles and, unfortunately, meeting terrible ends. The Nameless King, Solaire of Astora, and Anastacia of Astora are all characters that players can encounter whose stories culminate in heartbreaking ways. Perhaps the most forlorn charactesr in the Souls series are is Artorias the Abysswalker and his wolf, Sif.
Source:https://www.cbr.com/dark-souls-sif-lore-sad/