For making artwork it is enough that you know the materials of your software very well.
You know what happens when you crank any dial and can get the surface to shade as you like it.
Once you are very good at doing so you will realize there are really cool things you could do, but the software lacks nodes or dials
for allowing you to make it happen, so there is much merit in becoming a tech-artist yourself if you advance far enough in this art.
Actually programming shaders is def not required tho.
Still, studying the technical side of things a bit will give you a grasp of how things work and will demystify settings for you.>>507798>To make my own character's do you think I would need more than to be good at basic sketching?
If you're already good at basic sketching you have all the requirements to do well in modelling and sculpting.
But making characters is a deep topic, especially if you have animation in mind.
Expect it to be at least a 10 years endeavor to become anything like hollywood-tier good at it if you're just starting out.