Thanks for the answer!
Maybe just my expectations are too high, I have seen some of the tutorials that you linked before and did not use them as I don’t think they will help me with what I want to learn, all of those work well for some home made footage, they do not look realistic , they do not show specifically what I would like to do and so I didn’t use them.
The first link is a still image so I might as well do that in photoshop, the second link works with a 3D model as a base and just shows how to track a 2D object which I can do, rather than showing how to implement that into real footage. The third link completely does not look realistic, it also didn’t require using a 3D model because the object was so far away that a simple matte would do the job. The fourth link he just composites it in illustrator and photoshop and then pretty much just imports it into after effects.
I don’t actually think that anyone working with million dollar movies uses cinema4D, I keep on hearing about houdini and maya, but that’s the same thing with looking for tutorials for these two. I can easily find how to simulate a destruction of an object in houdini, but no tutorial shows a realistic composition of that object into the footage.
The only time that I can find something that looks realistic is in showreels, but then any tutorials are a massive downgrade. I was hoping that if such work is showcased that there will be at least 1 course that goes through an entire process of creating these super realistic scenes for big name movies. That way I would be able to learn the appropriate software, the pipline between what is used and so on.