Yeah, this exactly the stuff I like too. I have always like the trope of the ancient magic weapon, like Arthur's Excalibur, Sigurd's Gram, Beowulf's Hrunting etc.

Games like these are all heavily influenced by historical mythology for the most part and these magic items were a big part of that. Treating a few pieces of equipment as npcs almost (Even if they aren't intelligent and don't talk) adds a lot to the game for me.

An example I was really disappointed with was Anathema from DoS2. I felt that there was a missed opportunity to do so much more with it.