An ill-matched narrator can ruin an otherwise rollicking book. But a good one can bring stories to life – and evoke our earliest childhood memories