For all his on-set stories of The Godfather, the Oscar-winning actor’s account of his rise to fame is at its most compelling depicting his hardscrabble formative years