The mediumistic art of various cranks, crackpots and old dowagers is finally being taken seriously – and about time too, says Laura Gascoigne