Seth Godin wrote a book on this a decade ago, called The Dip. It's short, but a good book (and the Audible audiobook is quite good too).
https://smile.amazon.com/Dip-Little-Book-Teaches-Stick/dp/15...
https://smile.amazon.com/Dip-Little-Book-Teaches-Stick/dp/15...
It's a really great read particularly if you've been in a dip and / or a cul de sac (as Godin refers to projects that dip but won't turn back up). Being able to identify the dip and its characteristics allows one to prepare for it, and to have a strategy for not just enduring it, but for making it as much of an advantage as is possible.
Thanks for posting this, SyneRyder.