Oh god...that's like asking if there's any good operating system out there.
Plus, is not a thing of grabbing a 3D modelling program and start making transformers out of thin air.
First of all, this kind of software goes well into the thousands for commercial licenses. And you need quite a machine to run them on. Plus, tutorials are ok, but you will need courses (online or classes) that will add up.
Free alternatives are there. Blender is the favorite free modeler, and there are quite a few tutorials and free training around. Sketchup is not so good for animation or effects (I'm guessing you are aiming for that, since you are asking in a movie making form) it's basic modelling stuff, aimed at architecture.
Paid software is provided mostly by Autodesk. Maya and 3DSMax are both industry standard and popular among users. They have a steep learning curve, but there are many free tutorials and courses, along with paid ones. You can cover both modelling and animation, particle systems, and more. You can also add several plugins and features, from fluid simulation, to rendering systems.
Houdini is another good piece of software, but to be honest, I don't know much about it.
Zbrush and Mudbox are okay, but they are sculpting tools. They can be used to model, and it might be easier at first, but it's highly recommended to learn about conventional modelling first, to get afirm grasp on several concepts that serve as a base.
Poser is more of a, well, posing tool, and it's not recommended unless you want to get stuck with it. The whole concept of poser is to take pre-made models and pose/render them.
There is much to be learn about the subject. I would recommend you to watch a few tutorials on youtube, and a free trial for Max, Blender, Maya, or the like, and see which one fits you better.