In his masterly, wide-ranging survey, Joe Boyd acknowledges that many artists’ expectations are unrealistic – and that their music is often greeted with contempt by home audiences