From the Red Room in ‘Twin Peaks’ to the apartment in ‘Eraserhead’, the late director used design and decor to pull viewers into the subconscious