If you don’t want to go into the Noah’s Ark hoax then the Sodom and Gomorrah has no evidence but one city Tall el-Hammam may have had a comet burn up above it.

It is unknown why people left afterwards though there are theories

The connection between the two is that oral history is exaggerated so people remember it