I am also interested in this aspect. The most famous ones are Iliad and Odyssey, Aeneas and Ovid's Metamorphosis by Virgil in ancient Rome, and Spectrum by Shikhov in ancient Greece, especially Spectrum. From the first god Gaia to the replacement of three generations of gods, the origin of gods and the emergence of human beings are in line with your requirements. The first four books are all epics, and they are all stories of people and gods in the heroic era. Are you interested?