A "vociferous" public outcry about flood risks was not the main factor in a decision to refuse plans to build affordable ...