I think there's been some counterintuitive championing of both WATERWORLD and THE POSTMAN as being kind of underrated and fun but I think even people who kind of like them should admit that they are not movies that should be expected to be popular with audiences or justify their budgets.
And of course a huge piece of Costner's bankability that allowed him to make those was from ROBIN HOOD PRINCE OF THIEVES which sucks and has to be the least remembered movie in my lifetime to be the #2 movie in the domestic box office for a year
Robin Hood is hard to sell as much more than a low-stakes lark. Even with Rickman as the villain, he's not *that* dangerous, & Costner is abysmal at selling any of the drama.
IIRC they bought Rickman into the production by promising him he could play the Sheriff however he wanted, which makes his performance all the more interesting.