His gloomy, gorgeous paintings have been described as so powerful that they have tempted viewers to oblivion – but many were lost or destroyed. Next year, a major exhibition will gather some 75 together