The best advice I got was that not all advice is going to help all the time. And there's two sides to that, the first being that as you noted the pop-psychology listicle advice columns are usually too broad or for the lowest common denominator that they fail to help the people they claim to be giving advice for.
The other one that I'm constantly coming to terms with is that the advice that worked for me yesterday might not work for me tomorrow. My specific example: if I don't have a to-do list I don't have a hope of getting the things I intended to do done - but often having a to-do list makes the tasks overwhelming and it doesn't matter if that list is one or one hundred tasks. Pomodoros are fabulous, except when they're impossible to start. Gamifying is a great hack except when it isn't.
Incidentally, I'm looking at my to-do list right now, thinking fuck me, why did I write this?
The idea that not everything works is both liberating and a curse. Like, if something doesn't work then you can just try something else, no biggie. But sooner or later you'll have a thousand tips and hacks, and choosing which one to attempt to apply becomes a challenge of its own (fortunately there's tips and hacks for making that choice, unfortunately there's a bunch and they don't always work)
The most impactful and enduring strategy for me came from Tiny Habits by BJ Fogg. When it works, it works great, especially when my problem was starting a task - any task at all. It was also handy for breaking out of the thought that if I can't finish something entirely then it wasn't worth starting. As the saying goes, anything worth doing is worth doing half-assed.
It's not working today though. Maybe tomorrow