I have given up on aspirations of snatching; power snatching maybe but receiving overhead squat is a unicorn for me.
Dude, if I can learn how to do it so can you. I have like zero athletic ability. I was always the last kid picked for a team in P.E. class. And I was once like you. I could power snatch just fine, but a full snatch seemed unattainable. But I figured it out. If anyone is interested I can do a long post, probably in a new thread, about what I've learned about the Olympic lifts. And I've probably made every mistake in the book, and probably some mistakes that no one thought were possible to make. But here's a short teaser:
Doing the full versions of the lifts is actually, in some ways, easier than I originally thought.
Bar path is king and a correct bar path is a prerequisite to being able to do the full lifts. One of the reasons I had trouble with the full snatch, and in some cases the full clean, was that the bar wasn't ending up where it needed to be. I could do the power versions because there is more room for error. In the power versions you're in a quarter squat at most so you can more easily adjust your legs or "take a walk with the bar" to save the lift. Much harder to recover a lift from a squat.
The way to tell if your bar path is correct is this: when you do a power version you should be able to immediately squat down with the bar. If you can't, or you need to make any adjustment, your bar path is wrong.
It takes work, especially for the snatch, and you may need to exercises and drills that are considered "beginner." This was my problem. My ego got in the way and I refused to do the exercises and drills to improve my stability in the bottom position of the snatch. Having back surgery was the best thing to happen to my snatch technique. Once cleared for lifting, I had to go slow. Also, the bad disc in my back had damaged a nerve leading to my leg which resulted in weakness. I was weak, my squat went to the toilet. So I figured I may as well do some "beginner" snatch drills. It was enlightening.