>I still feel completely intimidated and out of my depth with modern assembly. I have no idea where to start.

I'm not surprised. But keep in mind that "create something that works on a modern CPU and beats the compiler's output" is not the only possible goal of learning assembly programming. I would say it's not even the usual goal, and hasn't been for a long time.