Despite writing some of the most influential sci-fi stories of all time, filmmakers have found it a huge challenge to adapt the work of Isaac Asimov.