Gary Naylor sees a long-running West End haunted house mystery and revels in its unabashed theatricality