What does the story of the flood reveal about Mesopotamian gods and peoples attitudes towards them?

The flood motif is actually a common to many myth stories, including the Bible. This is such a detailed topic for this short answer space. Check this out though:

https://en.wikipedia.org/wiki/Gilgamesh_flood_myth