Honestly? I can see this working for a few game, though not all. But one idea that shot right through my head...I know it would fall on deaf ears and such cause of the wave of comments and such, but here goes.
"You are a godlike being that has all of his powers, is stronger than Atlas than any given day, and can make a typhoon with just a sneeze. Upon his throne of gold, a small man in a black cloak appears, telling the 'God' of his achievements and greatness....but..there is one thing that even he can't control..
A Sword, a Dark sword that even the greatest heroes have died around it. Being the extreme being that he is, he would mock the little man in black, and thus take the sword for his own. Just as he conquers the dungeon that held the sword, word comes around that the 'gods' ancient enemies are attacking....something he could use his sword upon.
As time rolls on, however, it becomes apparent that the sword is draining him of his powers, and life, and once he figures it out, he us unable to let the sword go, either with the Golem' reaction of 'my precious', or not-believing it to be true of this wonderful sword..or the sword has latched onto him physically. By the end, he is soon mortal, and the little man in black happens to be the ruler of the invading army, or the spirit of the sword itself, and the Godlike-being, now human must conquer it before he falls, like the heroes before him.
So yeah, it would be a bit more like a 1player thing, 'but' it could be a multiplayer if you have more than one weapon and such.