I play musical instruments for two decades now. And I still enjoy it, because it puts my mind into a state that is almost flow like. Same for programming. So I just like how it feels when I do it, for the most part at least. That means sometimes I just program for fun and open ended without any goal at all. Same goes for music. 90% of my playing outside my band is just playing without a plan.

This is why I am good at those things — I spent a lot of my time doing them and I did so because I enjoy it.

Let yourself play, find the aspects that interest you about a topic and go wild. No need for a goal, thiose will come eventually. First you need to find joy in what you're doing.

And if you don't find any of that, maybe your motivation is just money, fame or whatever and thst might be ok as well, if you're happy with doing a thing you don't like.