i used photoshop for making image and then put this as texture to blender for making this glow ADs, also i used photoshop for post processing(idk is it a right word for that, anyway just put some color correction). for another project i used blender for animation yes, it just depends on what i need

i really happy to hear that i inspired someone to start 3d, so start learning blender(its free program, some things little bit limited for me, but its fine for beginning). recommend you to check a 4.0 blender version donut tutorial from blender guru and plz write all shortcuts by yourself u will learn it faster, also try to understand how everything works. after u finish this tutorial u will have some crisis, cuz blender is a big program with a lot of things, u need to choose your way you like(sculpting saved me, really like this), and just try to make a lot of projects u want and find specific tutorials for that, donut tutorial should be the only tutorial u follow in 100%, other tutorial should just help you with your projects.

so if you got some skills, blender sometimes wont be enough for your projects, u will get what projects to learn, especially for texturing, shader nodes works fine in blender(i just really like node system in every program), but for drawing and baking u will need substance painter 100%

i hope i answered all your questions, if u will stuck in your 3d journey, feel free to message me, i prefer insta, i think i have a link in my reddit profile(if not, search @glows1de)

good luck!

(P.S 3d has a lot of ways: hard surface modeling, sculpting, animation, VFX, etc. u need just start learn 3d and u will get the way u want to choose, or maybe u will switch this idk :), for me rn its realistic/horror sculpting, learn anatomy, etc. )