Professional procrastinator here. All the tips in the post are common knowledge and, sadly, not very good (especially in the long run).
The only thing that works for many people is to skip the motivation part and embrace the rather uncomfortable principle of "action before motivation."
The flow state will come. I believe it arises independently of motivation. Motivation just tricks us into believing that everything we do should bring joy.
It will — but not right now; we need to dive in first.
I also created and maintain a Russian "newspeak" dictionary: https://github.com/alamzin/az/