[Sheba]

Try Luin, the Spear of Lugh. One of the four treasures of Ireland, fabled for being insanely hot and having the properties elemental attacks.

Or the Spear of Assal, when thrown in battle, uttering the word 'Ibal' would always make it hit its target, and it returned to the thrower on uttering the word 'Athibar'.

I read it! In Slaine comic books!

Spoiler for Slaine with the mentionned spear:

Altho his signature weapon is his axe.