This book A First-Rate Madness by Nassir Ghaemi [0] is about that. He looks at various historical leaders and how one half of them make good wartime leaders, but bad peacetime leaders, and the other half -- the opposite. Some of his case studies are, as far as I can remember (couldn't find a summary online): generals in US civil war (Lee and the scortched-earth-guy), Chamberlaine, Churchill, Hitler, JFK, Lincoln, Napoleon, Nixon, Bush. US centric, but still pertaining to anyone.

[0] https://www.amazon.com/First-Rate-Madness-Uncovering-Between...