The book four thousand weeks by oliver burkeman or even just reading through his news letters is helpful to understand a different approach to time management and a philosophy of accepting finitute, I understand your issue, I am the same, but I think the freedom comes from understanding that you cannot win, you cannot find a solution to your question, there is just too much and always will be too much for you to do or that you could do and that is okay. Once you come to terms with that, it allows you to stop trying to do everything or follow every interesting path and get to work on something worthwhile.
I'm kind of surprised to see Oliver Burkeman mentioned so far down in the comments, but from personal experience this is the right thinking process.
What has worked well for me is Mark Forster's AutoFocus method, which is very similar (one long list where you pick what you feel like doing and re-enter if the task is not finished). This article explains it best: https://www.artofmanliness.com/character/behavior/autofocus-...
One benefit that I appreciated the most is that it allows you to trust yourself and your feelings. It puts you in touch with your inner self. it's kind of subtle in the sense that you only realize it after using the system for a few weeks.
Most existing time and work management systems work off of the assumption that you cannot trust yourself and that you're a lazy person or a procrastinator.