I am a huge fan of all Soulsborne and I will say that there are games with way better lore. It is good, yes, but also storytelling needs to be developed or the lore is severely crippled. I don't know anyone that plays/has played Souls games for their lore, usually they work through the game, with little to no info apart from random bits from items/NPCs, and then go watch explanations about the things they cannot figure.
Even then, a lot of it remains obscure. Who is the Iron King? Is it the same dude that had a relationship with Mytha? What is Ocelotte? What is with the painting girl? How many primordial serpents are there and why?
If I had to point to a game with stellar plot and storytelling I would say Mass Effect 2. I can still remember most of it ten years later and I never felt like something was left unintentionally unanswered.