I agree with your point, the issue becomes that while you want to write everything down so you don't forget it, if that item is months away from being relevant,

I agree with your point, the issue becomes that while you want to write everything down so you don't forget it, if that item is months away from being relevant, you have a large cost of having to read/see it constantly and figure out it's not important, multiple this by a large amount of tasks and it soon becomes overwhelming. The method I try to use, is am feeling a weekly review where I review everything and check in with myself to see how I am feeling, what i got done and if i am on track, from there I can choose the things that are relevant to this week and ignore all the other tasks. So when it comes to managing things on a day to day basis, my brain only has to deal with stuff coming up this week, safe in the knowledge that I have taken the time to think through everything else.