It is not possible to determine which creation myth is most memorable. It depends on the audience (things I find memorable, you may not and vice versa). Various cultures possess creation myths that have been past down orally and in writing for several thousand years, a fact suggesting that all those stories have been extremely memorable within those cultures. In general, the narrative form of creation stories from the Old Testament, Sumerian epic, Navajo tales, Hesiod's Theogony, etc. makes the stories memorable.
The narrativization of creation myth suggests that the sacred was viewed anthropomorphically in these cultures, and that many aspects of human-divine relations were explained by means of a causal narrative chain instead of existing in, for example, a timeless or transcendent present of abstract metaphysics.