Can brand activations through experiential events such as music festivals provide good mid-long term ROI?

Yes. Especially if there is an app or recurring behavior being promoted during the activation.

Then the activation becomes a well-placed advertisement, which elicits some immediate behavior, which is then repeated post-activation into perpituity.