Despite 50 years in the business and multiple Oscar wins, the veteran director still struggled to get funding for his latest film. Here, Geoffrey Macnab looks at why Hollywood will always be suspicious of the man behind ‘Apocalypse Now’ and ‘The Godfather’