I've worked through a couple of these lists and a few of the projects. My take on them is that many of the tutorials are not vetted for quality or even completeness. I have several projects where the author of the guide essentially 'gives up' 60-80% of the way through, usually in the most difficult stage of the process, in what can be described as a 'rest of the fkn owl' result.

Also as someone who easily succumbs to analysis paralysis, this has made it quite difficult to motivate myself to start another one.

I agree. I’d pay for a "course" that assembled a massive list of practical learning projects like this into something that plots real skill/knowledge growth from beginner to advanced in a structured way.

Maybe you're interested in a platform I've built for this kind of thing - https://readpaths.com. It lets people collaborate to build something like what you describe. People can add links and other people can add connections between these links, resulting in a dependency graph.

Pick the one that seems most mysterious and scary.

Alternatively, pick the one that seems just a bit too mysterious and scary to be able to do yourself.

It hasn't for me. If I didn't have any direction, sure. But if there's something I actually want to learn, it's easy to find a good source and then hold my nose to the grindstone.

Roll a few dice.

Too much choice can be paralyzing, yes.