Yeah, Hammer of the Gods is good. I read that years ago. I think I gave my copy to my niece.
Jimmy Page: The Definitive Biography by Chris Salewicz is good, and it's pretty up to date (published in 2018). I really enjoyed it.
I also liked Peter Green - The Biography by Martin Celmins.
As much as I like EC, I did not like Slowhand by Phillip Norman. It was published in 2018. I guess Norman is a highly regarded author, but I just didn't enjoy the book.
For a little light reading, try Stone Me - The Wit and Wisdom of Keith Richards compiled by Mark Blake or What Would Keith Richards Do? by Jessica West.
You're right, Sgt. Pepper; some of one's idols and heroes are not always very nice people.