If I have to give my recommendation, I used "Idiot's Guide: Music Composition" by Michael Miller. It required a lot of background reading, but once I understood chords and chord progressions well and melody construction it started, slowly, to come together. I don't know that it's a good book, but it worked for me.

I then read "A first book of blues, for the beginning pianist" by David Dutkanicz, which led me into blues which is kinda its own thing, I couldn't apply some of the algorithmic rules I had learned to the blues scale and I wanted to understand why. Admittedly the book didnt teach me the background theory of why that is the case but I did learn more concepts like syncopation and ways that the blues scales are constructed from a major scale and why