The Hollywood icon boasts one of the most prestigious portfolios in the business - but not all of his films were an instant box office hit.