You are not alone, soooo many people, myself included, are like this. As are many with ADHD.

For me, I found listing out the things I want to do for each project (the details, not the name of the project), and putting them all low priority works. Then I move a few to high priority and tell myself those are my “tasks” for the week.

That stops me from going down the rabbit hole pretty well, while still enjoying my time. I find the number of tasks fluctuates, mainly because after a while of shifting between TV, games, and reading in the gaps, I get that feeling of wanting more productivity being fun back. Which sounds like the feeling you want.