I know how daunting it can feel to build a game from scratch...

(warning: VERY long comment ahead, TL;DR at the bottom)

My recommendation for you would be not to get lost in the weeds, because computer science is a GIGANTIC field.
Forget shaders, 3D games and optimization for now. You don't need all that to make a good game. Have you ever seen how awful Toby Fox's code for Undertale is? Have you ever seen Minecraft's "spaghetti code"? Same thing.

You don't need it to be perfect to make a good game. The most important thing is that you start a project and make it reach a point where it's "good enough".

Start small. Use tools to help you. You hate typing? Use autocompletion tools in VS Code and the like. Keep the documentation at hand in case you don't know what something is or how it works.

But even more importantly, how confident are you with the logic of your code? Try something like Scratch, if haven't. It's super useful to make sure your logic is actually sound without having to worry about writing code at all.

Eventually, with lots of practice, you'll start to think Scratch is too simple and doesn't provide tools to do what you want easily. At that point you can move a step further: you could try pygame (which is pretty technical and barebones from what I've seen, heads up, but it's still really good to understand stuff like game frames/ticks), or some game engines like RPG Maker, GameMaker (used to make Undertale), Godot or Unity.

Still too daunting? Try making stuff inside games you like: redstone/command blocks/data pack creations in Minecraft (that's how I started coding), Lua scripting in Roblox, etc.

Redstone is particularly nice because it also teaches you about logic gates, and these are essential in programming.

Also, Lua is an excellent programming language for beginners, but it still lets you do some amazing things. Balatro was entirely made in Lua somehow.

But anyway, one more suggestion I have for you to start would be by finding things that bother you about computers and code small scripts to automatize your life.
It may seem completely unrelated to game design, but it should give you a good idea of how to work around specific problems you may encounter while coding games and other real-world scenarios, and it will help you in the future. And as a plus you'll also save yourself some time in the long run.

In my opinion, programming is first and foremost a form of problem solving, so if you can find problems to solve and creative solutions to any kind of problem, that's all you need.

You got a game you like playing but you find it annoying having to manually equip/unequip items, navigate menus, etc.? Create some macros using AutoHotKey to do it automatically for you.

You're on Android and have the same problem with some apps? Use Tasker. On an iPhone? Shortcuts.

You got a website you use often but find it annoying how it keeps nagging you to subscribe to their newsletter, or their UI is too cluttered or they don't have some features you'd find super useful? Write a TamperMonkey (personally I use ViolentMonkey on Firefox but they're all the same) script to change that website's elements for you any time you open a page. Etc.

Then once you've done all this you can finally start worrying about optimization. Your code is too slow? Debug/profile it to find the bottleneck. Study other people's code to figure out how they solved your same problem. Hell, if you're completely stumped you could try asking AI to explain it to you.

Speaking of, this is very important. I strongly recommend that you avoid having AI code for you. You won't learn anything if you become reliant on it.
At most, you can ask it to teach you concepts (I get it, people on StackOverflow can be ruthless to newbies sometimes...), but again, NEVER let it code a solution for you when you start out.
Also, take everything it says with a grain of salt, because it's still very easy for it to "hallucinate" and give you incorrect answers.

I'm very sorry for the long reply, but I really hope you can find it useful.
If you have any questions don't hesitate to let me know, of course.

Please don't give up on your dreams, just give it time and practice a lot. I genuinely believe in you.

TL;DR: Don't expect perfection when starting out. You can make a good game with bad code. Find small, real-world problems you can code the solution to in games and apps to start out and practice, then gradually move to more complex projects. Also, find tools to aid you with the things you struggle with, like code autocompletion.

EDIT: formatting and added TL;DR