In the USA, near New York, I saw houses with swimming pools along a highway leading out of the city. Everyone has their own views on what they consider important ...
I once wanted to buy a house that is located directly on the Werra. When I arrived at the property, I immediately felt really good (living by the water, I usually just find it really beautiful).
Besides, it was extremely cheap.
I thought about moving there and thought about how I could deal with the disadvantage of very likely having water in the ground floor from time to time.
If the flood risk does not have the advantage of the beautiful location, I wouldn’t even consider it.
After thinking it over, I decided: I won't do it. There are simply too many disadvantages, which one could counter in some ways, but it remains uncertain and the annoyance is foreseeable.