I think many players like the idea that the end is not predetermined, and that they can have an impact on the story, rather than having the ending predetermined by the referee. In that way, RPGs are not like books and movies (which exist to communicate the author's ideas).
