I know it’s not a book, but I enjoyed every single episode of this series I was able to watch: Classic Albums - Wikipedia - maybe you will find some of what you are looking for here.
From me +1’s to “This is your brain on music” (Levitin) ; “How music works” (Byrne) + being The Roots obsessive I also enjoyed Questlove’s “Mo Meta Blues” & “Creative Quest” - AMAZING thread - thank you all for your contributions - 7 books in cart for now