Hey, welcome.
Most general modern DCCs like Blender, Maya and Houdini do everything well.
Depends on what kind of workflow you’re looking for. Of course it’ll be confusing and difficult to learn something for the first time. Don’t expect to watch one video and get comfortable with a new 3D package, especially without any prior experience. Stick with something and work through it.
It also depends on what you want to do. I still think it’s extremely beneficial to have some experience with traditional box/poly modeling/uv/texturing and then going on to learn procedural techniques like Houdini/Designer.
The most important software IMO is your engine of choice, you’ll spend most of your time in it.
And of course, these are all just tools. You just use them to create meshes or shapes or data to use creatively in a more holistic effect. All of them are used by professionals all the time. For example, I’ve only ever used Blender at work. And it’s great.