I understand. And first of all, I am not frustrated at all, I am glad to be able to assist you in any way that I can
I notice that in Ball3 image you have 2 new camera components newvar and newvar0. Could it be that you are setting the camera to these? Your HitCamera should follow your actor. Try removing these new camera components.
On a side note, I realized that you do not need to manually set the camera back to the character. This automatically happens when your projectile gets destroyed.
New Video. Notice that I set up my actor’s components as yours are. Minus the destructible, since I did not have any destructible mesh’s. But my static mesh follows the same hierarchy as in your actor. The only way that I was able to break this mechanic in a similar way that you mention was by creating a new variable of camera actor type and using that to Set View Target with Blend.