re: I just read Kevin Costner turned down the Andy role in Shawshank for Waterworld

Waterworks was the most expensive movie of all time to produce at the time if I remember. They wanted it to be huge at the box office. There was a lot of advertising for it as it became closer to the opening date.