Since I find these book recommended on HN a lot, I guess it's my turn to share them as well.
The War of Art [1] and Do the Work [2] both are excellent books about making things and why it's hard. I found them motivating not only because of the solutions in the books but also just because someone describing the problems I have with creating, so clearly, is helpful to read. It's nice knowing you're not a crazy person and that these are problems a lot of people go through. They're also very short and easy to read. So give them a shot.