I am an absolute beginner in coding & Gamedev and I need advice please.

I have a passion for coding and making games, it is something that excites me so much but also frustrates me a lot and even causes me to be depressed not being able to make what I want to make. I am lost when I start diving into a project. I depend on YouTube tutorials to learn C# in Unity and how to move a 3D player. I have learnt how to use Blender in the past month and I am confident in making 3D game objects, but taking the next step only frustrated me over and over again. Are there any mentors that could help people like me?

Please, If you have any motivation & things you can suggest do so as I am starting to lose hope in myself.

I feel you, but I strongly suggest you to keep up the good work and continue your journey on making games. A great way of learning coding is just leaning on Unity forums on each of your questions how to do something and trying to understand it. Youtube videos as well can come in handy, in fact they can explain complex codes in the simplest way so I reccomend every time you face an obstacle just search it up and not stop it cause the main problem in making games is that people lose motivation before the jackpot hits in. Keep it up brother :).

Ever checked out Thomas Brush on YouTube? (I am not affiliated with him) He’s got videos not only on coding issues, but also on emotional issues- including depression and wanting to give up. Plus, he does program in Unity- which is a nice cherry on top.

If you are willing to put some money into learning, also check out AwesomeTuts.com (again, not affiliated). It’s an academy that you pay a monthly fee, but you get access to all of the content on the site, which includes things from several game engines. You do not get certificates for completing them, however- you get knowledge. It’s something he specifically states about the academy. If you want to just have a free trial of it, he has a free video on making games, and a few things he shows you on YouTube.

If you’re not satisfied with that, or just want a little more, try a pathway on Unity Learn. The teachers there break stuff down very well.

Hope some of this helps.

This place is more for specific problems than general advice, but I would stop using unity and learn C#, make a text adventure, then you can learn the language without having to worry about game engine libraries or graphics. Once you can make a really good text adventure and you understand C# going back to unity will be easy. 90% of beginner problems I see where peopel are saying they are having unity issues they are really C# issues, like trying to assign a string to a method, that won’t work in any game engine, you need to learn C# syntax and variable types, conditionals and boolean logic, collections and loops, methods, classes, Object Orientated Programming(OOP) which will be stuff about inheritance, classes versus instances of the class, static variables and that just scratches the surface once you learn all that you need to learn code architecture so you can make bigger games and you need to learn common programming patterns, state machines, mainly Finite State Machines(FSM). You learn all that and then you will be ready to start learning advanced programming.
Once back in unity you make small games that you will be able to finish, stuff like flappy bird, pong, falling hats… really simple stuff. If you make games that have just one mechanic that you will want to use for your dream game, it will help you later when you get to that project. Join game games, great way to practice and meet other developers.
Working on a big game as a beginner will burn you out and most likely cause you to give up and quit. To make a big game you will need years of knowledge and experience. If you are ready to dedicate years into learning than proceed, making a game is not something to take lightly.

I started with youtube tutorials like this: How to Pick up and Place objects in Unity P1 - YouTube
Then, I used a lot scripting API (Unity - Scripting API: Physics.Raycast) to find the snippets I needed to achieve my goal. I also learned some basics by googling for specific issues I had. By doing that, I was learning how its works (I’m a craftsman, had no programming experience ever before). There is a lot frustration and I scrapped many attempts after months of work because I got to a point where I knew how to solve things better. Now, 3 years after, I write my own physics for space-simulation-game, all from scratch.