Bradford Nordeen remembers the late American filmmaker’s carnality, decay, hurt, humour and so much excruciating beauty