I used to beat myself up over not finishing projects, until I learned that I have #adhd. My interests and motivation shift severely on a daily basis, which isn't really compatible with long term commitment.
I'm now trying to lean into it and enjoy the process of creation while putting less value in completion. Capitalistic society wants us to value the "finished product" above anything else - that doesn't mean I have to.