A survey of the artist’s work takes us to a land of sinister magic not so different to our own, writes Eleanor Birne