Totally recognized myself in a lot of things you wrote. What helps me a little bit is a “could do list” besides my regular to do list. That one is really long, altough i review it on a regular basis and delete ideas / tasks that aren’t a good fit anymore. And always glad i didn’t invest time immediately in them when they came up.
“The One Thing” by Gary Keller might be a good read for you!