There have been a couple of threads with answers on the impact of Live Aid, Band Aid, and USA for Africa, so I'll link them:

u/wilbarp provides a thorough account with plenty of further discussion in Did celebrity efforts like Band Aid's "Do they know it's Christmas?" and USA for Africa's "We Are The World" actually help alleviate famine in the 1980s?

u/ReaperReader answers in What was the real impact of the Live Aid concert of 1985?

Hope this helps!

Miles Moreland in his book "Cobra in the bathtub" argues that it did great harm by having people think of Africa as a single entity rather than 50 or so individual countries that make it up with distinct geographies, people, histories and issues which has resulted in "solutions" which are not focused on specific issues but on general idea of "African-ness" and therefore either unequal in effect or completely ineffectual (much like applying the same "solutions" to Germany and Albania or New York and Arkansas and assuming that they must equally apply because both countries are in Europe / USA).

However given his writings are anecdotal, I will submit myself to the Mod Gods for judgement.