Heracles no Eikou II: Titan no Metsubou

Heracles no Eikou II: Titan no Metsubou (ヘラクレスの栄光II タイタンの滅亡) is an RPG developed and published by Data East for the Famicom in 1989, exclusively in Japan. It is a turn-based RPG and the second in the Heracles no Eikou/The Glory of Heracles series of games. The game is centered to some extent on the Twelve Labors of Heracles, and ultimately involves rescuing the goddess Venus (Aphrodite) from Hades, the King of the Underworld. Notably, Heracles is not the protagonist, but does join the party as an NPC.

Though largely a traditional turn-based JRPG in the vein of a Dragon Quest, the game has a few uncommon features. Item durability, for instance, is a constant problem unless the player hires the blacksmith god Hephaestus to join them as an assistant NPC. Otherwise, they need to return to him to fix equipment. Heracles can use any weapon though certain weapons are more effective against certain enemy types, for instance spears against sea-based creatures. There's also a day/night cycle that determines the opening hours of specific establishments.

Though never officially localized into English, it eventually received a fan translation in 2005, which can be found here.