Maybe I'm misunderstanding the Diamond example here, but I think of him as precisely a cautionary tale for academics, of what can go wrong when they try to go too far in the pop-science, big-picture, broad-audience direction. Diamond is solidly an academic, not some kind of outsider... he's held a professorship at UCLA for 50+ years. But later in his career decided he wanted to write "big history" interdisciplinary synthesis for a popular audience.
I suppose one could try to write for a popular audience without going that far outside your own discipline/expertise though.
I'm also seriously baffled by people who try to portray his views as racist of eurocentric. His preface explicitly spells out that Europe was a backwater until the early modern period. In fact, a large part of the motivation behind Guns, Germs, and steel was to debunk the idea of wester cultural or racial superiority, and provide a compelling counter narrative to those explanations of Eurasian-American divergence.
This sort-of goes too far. The Roman empire at its height was very much not a backwater. What is pretty unique about Europe is the subsequent enormous loss of civilizational complexity in the Early Middle Ages combined with the fact that it could, albeit 1000 years later, drag itself out of the hole again.
Also - generally speaking, I think being able to speak (or write) in a manner that's compelling for audiences across broad backgrounds, rather than just their niche community is a skillset to be admired.
Science does nothing if people do not believe in it, or do not engage with it.
I definitely agree that this does not give academics license to veer entirely outside of their expertise and use their credentials in the field to hide this (eg: Diamond). But I think not trying at all is worse. Far worse.
Could you elaborate a bit?
Myself I found his books quite compelling. I'm of course not an anthropologist, historian etc. so I may be missing something big.
As for Guns, Germs, and Steel itself, it's not quite as bad as Collapse, but it does have issues. The underlying thesis--of geographical determinism--just doesn't hold up to actual evidence that well: there's not a lot of evidence for Neolithic technology spread in the east-west axis of Eurasia, especially in comparison to the rather prolific spread you see in the Americas. In particular, cereal crops: you see very little spread of cereal domesticants between Mesopotamia/Mediterranean and East Asia, while maize spreads from Mesoamerica well into both North and South America, supplanting indigenous crops in both places.
The deeper issue with GGS, for anthropologists in particular, is that it has an underlying presumption of a unilinear model of civilization--essentially, the idea that something like the tech tree in Civilization games is a good model of how technology works. In anthropology, this model is deeply discredited, as it performs extremely poorly, especially when you look at cultures that straddle chiefdom/state societies.
The tl;dr is basically that part of an academic's job is to educate not just the professionals but also the lay public. By using fantasy and other pop culture works, he's introducing pretty important military history and theory concepts to those who wouldn't otherwise attempt to wade into it--and if they enjoy it, they might come back for some more pressing and serious can't-sugarcoat-this topics such as the implications of Russia's invasion of Ukraine.
In general, I would say that academics all too commonly forget the need to engage with people outside of their narrow disciplines, and in doing so, you can cede the field to engaging writers who are way out of their depths and horribly wrong about what they are writing (e.g., Jared Diamond).