RE: I've come to the conclusion that I suck.
Others gave good advice. You seem to be "book smart" when it comes to hunting and have had some great experiences afield. Put that knowledge in place - step to the next level, be smarter. Deer are funny critters but have a great zest for staying alive. Out smart them. Set up an ambush (ground or stand) and play it out patiently. You'll do fine.
I started bow hunting when I was 12 and didn't get my first until I was 18. Those six years taught me a ton. It took so long to get good at hunting because I didn't have a mentor (or a freaking clue of what I was doing) - I learned on my own. Get a good hunting buddy. It helps.
Also, deer hunting can get wierd at times. Years ago I went two seasons without getting a deer. I spent tons of time afield in bow, gun, and muzzleloading seasons and couldn't bring anything together. It happens. On the other hand, some times it goes well - my son bagged his first deer this year after spending an hour in the stand - his first hour of hunting, ever.
So, don't give up, and don't give up learning more about the game you hunt.