No, they don't help if you're referring to "productivity hack" content.
Procrastination imo is far more related to your neurology – most of which is beyond your control.
I can't speak for others here but in my own life depression isn't really a demotivator unless I feel my circumstances are out of my control (which is rare), otherwise feeling crap about something is probably one of my single largest motivators to fix it.
I don't have ADHD so can't speak to that.
What works to some degree for me personally is just considering my brain's reward system. This will sound weird, but personally I find taking a bunch of caffeine exclusively when I'm do things I want to be motivated to do works very well at keeping me motivated to do that activity.
Caffeine is an easy way to give you a boost of dopamine so if you can associate that with an activity you'll just find you're just naturally drawn to that activity. I'd also recommend L-Tyrosine and L-Dopa if you want to get a bit more experimentative, however you'll need to be careful about how regularly you use these. Artificially boosting your dopamine levels can demotivate if it's not done in a targeted and infrequent way.
The other thing I try to avoid is negative emotions during activities I want to be motivated to do. If I associate a person / thing / place with a lot of negative emotions I find I disengage with time. Specifically stress is probably my biggest negative demotivating emotion.
The effects are subtle and take time, but they definitely work. I hear nicotine gum is amazing for productive too if you use it very infrequently. I've not tried it myself though because I'm not sure I'd be able to regulate myself.
I doubt any of this is going to help much if you're naturally a lazy person though. It just helps me a bit, although I've never had much of issue with procrastination anyway.