The father of psychoanalysis had a profound influence on literature and art as well probing the darkest recesses of the mind, writes JP O’Malley.