The American filmmaker, who has died aged 78, leaves behind a body of work exploring the rot of evil and the mysteries of desire.