If you are the best in the room, you're in the wrong room
Theoretically someone will always be the best in the room so this sounds like a recursive problem with no solution if everyone is scrambling out of the room they find themselves to be the best in XP
I am aware that I both take everything too literally and overanalyse everything too excessively
trying to shadow people that I want to emulate
I did this with my boss when I first started working. After my shifts I would jump into her class and quietly follow her around and ask her questions when she wasn't directly busy with the students (her groups are at an age/level where she can sometimes sit back a bit and watch them from far enough away to be able to make sure they're doing the correct things rather than having to be directly under/next to them to be able to catch them if they screw something up). It was incredibly useful and I learned a lot and I only do it every so often now and have many new "stupid" questions for her.
One of the best learning methods out there I think, and usefulness increases immeasurably if the person you're shadowing also happens to have teaching styles compatible with your learning ones.
I lucked out, my boss knows how to deal with brain glitches
I don't think there's anything wrong with the guidelines but guidelines shouldn't make an intelligent individual be prisoners to it
A guideline is a direction you should go in not a script you need to prescribe to verbatim. You (and the seniors before you that you were emulating) did exactly what you were supposed to do with it (model your interview/questions on the guideline but ask/carry it out in a way that works for you to be able to get the answers that you need to be able to do your thing).
then that's the time I've probably outgrown an area and try to seek another area to get better at
Definitely a way to do things if you're getting bored. Another thing you can do is be the mentor for others walking a similar path to you.
The "street smart" attitudes always have a practical use. In my limited experience much more useful than just knowing how to look up an answer in a book and being completely confused because there's conflicting answers and all or none of them are right to some value of right (which I feel is where a lot of the world's problems are).

What amazes me about this approach is that it's simple and yet people often miss doing this in the workplace or at school. Rather than spend so much time doing exactly what everyone else is instructed to do, why can't people seek out other people who do exactly what they were told but add a twist of efficiency they personally made up while doing the task. I do believe it's easier to learn or shadow someone whose values you already align with work ethic wise and there's much to learn from acknowledging we don't know that's why we ask that stay silent and pretend to know. Nowadays, I rely on this tool chatgpt to reduce my need to look stupid by asking questions first or anticipate possible questions my mentors ask just to get on their good side and tell I'm listening.
As much as there's "improvements" over time and also amazing school teachers who do their absolute best and genuinely make huge differences in lives and educational careers, at its most basic core, the school system is entirely about making people just shut up and do as they're told (and also accept what they're told as gospel truth that should never, ever be questioned because the people telling you so know better than you ever will), that's more or less what it was originally designed for. So the average end result isn't a big surprise.