The Noonday Demon by Andrew Solomon is a pretty decent book. I am currently listening to the audio version.

Considering reading: A First-Rate Madness
Uncovering the Links between Leadership and Mental Illness
by Nassir Ghaemi

This looks like a decent book to study what some of our historical leaders may have gone through.