Director of ‘the greatest film ever made’ died alone and broke, was forced to beg for money from his peers: ‘Erratic, self-destructive, egotistical’