I haven't read the thread but maybe I could offer a point of view from someone who lives in a house that has been flooded at least twice in the past 10 years. I've lived in my house 20 years and am happy to stay here and take the risk.
Over the years I've done my very best to flood proof and protect my home, so stone walls and floors, electrics up high, good quality oak doors that aren't affected by water. I have put so many different measures in place that I forget a lot of what I've done. However, if I see the possibility of a flood approaching I can protect my possessions within 30 minutes. I'm fortunate that water doesn't come in very high so all furniture is lifted up above flood height. All I have to do now is dry out the house and clean, which isn't pleasant but is only a couple of days cleaning really. I haven't even put in an insurance claim for the last 2 floods because I lost nothing.
I knew my house was a flood risk when I bought it, but it was cheaper than the car we drove when we bought at the time (not in the UK). I've spent a fair bit doing it up over the years and I love it. It's beautifully situated and at this time of year to be in my garden and surrounded by birdsong and wildlife make up for it. It was amazing for my DCs as children, living where we live has given them an amazing childhood.
It's also a big family house which has accommodated my family very well. I know very well that my house is worth less than other houses in the area, by about 20 - 30k, however it is now in a highly desirable area where wrecks are being bought at stupid amounts of money. I think in a few years, once my DCs have left and the house is too big for me that it will provide a lovely family home for maybe a couple trying to get onto the property ladder. They will get a great home for less money than smaller, less well renovated properties, and maybe they will be happy to take the risk.
I do watch water levels avidly as I'm situated between 2 rivers, I am shocked this year at how much the water levels have dropped, but then we haven't really had any rain at all this year.
I also have no trouble insuring it and my premiums are not high at all, but this is possibly by virtue of not being in the UK.
It's not pleasant being flooded, but for me in my home it's worth taking the risk.