It sounds like he's interested in special effects and for that he may want to add Fusion Studio ($300). I know industry pros who use this software but imo it has a high learning curve.

For something more accessible top choice is probably Adobe Premiere + After Effects. It's what most kids seem to use these days, if they have the money or student access.