An example: Classical Mechanics.
Goldstein is the de facto graduate text on the subject.
I haven't used Hand, but what I could get with the "Surprise Me" feature on Amazon, it looks like a Undergraduate text. I however used Marion and Thornton.
There also seems to be some misunderstanding in HOW to order it too. Like you have Mechanics in the beginning. What do you mean by that? The first round? ie: not Classical Mechanics (Junior year). If so, those books are typically a trifecta, containing: mechanics, E&M, some waves, and some modern. Those are typically Young or Halliday and Resnik.
You also separate electricity and magnetism into different sections, in the undergrad section. Why?
You have QM but don't have Griffiths? You have E&M but don't have Griffiths?
Why do you have Sakurai and don't specify which one?! If anything says "Modern" in the title it is probably a graduate book. I can't see inside that one but it is frequently bought with Jackson (E&M) and Goldstein, so I would take a stab at it being a graduate text.
If you want to self learn, well let's go through some books and then youtube channels.
Books: Missing Discrete and Graph Theory
(You can get previous versions to save money. The content of these is mostly the same). Mostly in order of level (math then physics)
Calculus: Stewart's Calculus (this is pretty much the standard) This has calc 1,2, and 3 (multi variable)
Linear Algebra: David Lay . Start sometime after calc 2 (series problems). This will start you on some optimization and constraint solving. Stress learning eigen values/vectors and least squares. I don't have a good level 2 book, but that would mean looking into coordinate transformations, QR decomposition, and some more stuff.
Differential Equations: Blanchard Differential equations . You will need diff eq to gain a true appreciation for physics. You will also gain a lot of the pre-req's for optimization and constraint solving.
Physics: Halliday and Resnik is one of my favorites. But this is the lower college level (3 courses: Classical, E&M, Rel/quant). If you are relearning you can skip to below (though you might struggle a little more) Req: Taken or taking Calc 1 (differentiation and integration required later)
Classical Dynamics: Thornton You will learn A LOT about constraint, optimization, and simple harmonic motion (necessary!!). You will also learn about Hamiltonian Systems. (1.5 courses) Req: Diff Eq, Calc 3
Electrodynamics: Griffiths . Another standard. You won't find a better book than this for E&M. (1.5 courses) Req: Diff Eq, Calc 3
Quantum Mechanics: Griffiths  (He's the man, seriously) (1.5 courses) Req: Diff Eq, Calc 3 (lin algebra is nice, same with a tad of group theory)
Astrophysics: BOB  Lovingly called the "Big Orange Book" you will see this on every astrophysicists' shelves. (2+ courses) Req: Calc 1
Particle Physics: That's right! You guessed it! Griffiths! Take after QM.
BlackPenRedPen: Fantastic teacher. He will help you with calc and help you understand a lot of tricks that you might not see in the above books. I can't stress enough that you should watch him.
Go find MIT OCWs, I'm not going to list them.
Honorable mentions: 3Blue1Brown, Numberphile, Veritasium, StandUpMaths, SmarterEveryDay. All these people talk about some neat concepts that will help you gain more interest and think about things to pursue. But they are not course channels, they are much more casual (somewhere between what you'd see on the Discovery Channel and a classroom, more towards the latter).
> I follow a bunch of folks on the internet and idolize them for their multifaceted personalities
Don't stress too much about being like those people you idolize. I guarantee that you see them as much more intelligent people than they are or think of (not dissing on them, but we tend to put these people on pedestals and this is a big contributor to Imposter Syndrome. Which WILL have, probably already does, an effect on your learning process). Don't compare yourself. You can get to most of these peoples' levels by just doing an hour or two a day for a few years.
> I can totally see that these are the folks who have high IQs and they can easily learn a new domain in a few months if they were put in one.
This is a skill. A trainable skill. Just remember that. Some people are much more proficient at it, but I be you'll see that they have much more experience. In music you sight read. Doing the same thing with math, physics, engineering, etc will result in the same increase in talent.