Are people bad at their jobs or are the jobs just bad?

I recently retired after 45 years in tech. I started out in 1978 at Bell Labs. I have had great jobs and terrible jobs. Great bosses and horrific bosses. And all the things in between. I did not just survive, I thrived and beyond and worked at 3 start ups and a bunch of other companies large and small. What I learned is to not to be afraid. Regardless of what is happening around you. Fear is the enemy. Don't be afraid to be weird or crazy or whatever is causing you to be timid.

As someone who is more in the middle of my career rather than the end of it, I would like to echo your sentiment. I have had plenty of roles where I was tasked with things that were out of my depth, and the answer is to just not let it be. There is always a path to get the answers/skills you need to do what is asked of you, you just might not know the path yet, so the core skill (and where I think fear comes into the process) is accepting that not knowing something now is never a hinderance so long as once can do self-directed learning. The rest is reality testing if what you just learned is actually able to solve your problem. If it isn't, then repeat ad infinitum until it is.

How do you slog through something you truly hate?

More than a decade ago I was hired as an intern at Colgate-Palmolive as a software developer. Turns out they were(are?) one of the largest SAP deployments in the US. The entire company revolved around SAP. Due to lack of college graduates knowing SAP, they took great pains to treat me extremely well and train me (a CS major) in ABAP using SAP Netweaver.

My project was more ambitious than the rest of the group because I had enough courage and bravado to be assigned a project like that. In fact I made it a point to be 'brave' and make myself look really good in front of the upper level managers. I tried to know everyones name, even in other departments and to be super polite and humble around any sort of manager there. When I finally got some tasks to do, I was so miserable that I finished multiple days without getting anything done. I felt so depressed thinking that I slogged through four years of CS for this?

In the end I managed to finish last in the cohort and Colgate took the rare(at the time)decision to not extend me a full time offer. I felt like a complete failure because I didn't put in 100% and I felt like I let my mentor down.

At the same time I know that I truly hated it. To this day seeing pictures of SAP GUI gives me anxiety and makes my stomach turn. How do you overcome something like that and push on? It does not always seem like a sure thing. I sometimes think what if I had pushed through and gotten the offer? I'd probably still be at Colgate like my mentor was.

With the benefit of hindsight I have learned to be super appreciative and thankful for them treating me so well but im glad circumstances led me to not ending up there. But really who knows if it would have been better in the long run? Whenever I see Colgate it actually evokes positive memories of that time. But the biggest thing I learned was to not bite off more than you can chew and if you don't truly love what you are doing there is another path out there.