For all of my life, I have always lived near water - in many cases within walking distance of a lake, a creek, canal, river, or a pond. I cannot imagine living somewhere without a body of water, but I also cannot imagine going through some of the cataclysmic flooding such water can bring. Any floods near me have been, well, not devastating.

Oceans are okay, though with the latest tsunami threats in the Pacific, I'd be happier on a calm cruise in Estonia.
Rivers in a city are especially attractive as they provide an opportunity for bridges. I have been known to go miles out of my way for a waterfall or bridge. (I've been to Milford Sound, but not Prague)