Driven by a hunger to return to the purity of the Caeliar, not simply a will to conquer. Thus the solution wasn't to simply destroy the evil, but to heal it, removing the hunger and taking away the source of the evil, finding a solution other than killing every drone and the Collective.
I directly quoted Picard's words in Voy:Scorpion:
The complete quote sounded ~'Do not expect reason or compassion from the borg. They feel no pity, no remorse, only the will to conquer.'
And Picard had an intimate knowledge of the borg mind, Kestrel.
And the 'solution' had nothing to do with 'our heroes'. They were just there to whine and die.
Picard had intimate knowledge of the Borg, yes, but he was also deeply wounded and scarred by them; and he didn't know the entire truth of the Borg. Of course he puts it in terms that he'd understand and that he relates to what happened to him - basically, Picard is the best expert on the Borg (after Janeway) but his perception of them is naturally (and understandably) skewed. Christopher put it better than me, but the conquest that the Borg sought was not simply establishing dominance but subsuming identity and establishing a perverted version of the "unity" that whatever remained of Sedin's consciousness had clung to, impossibly enraged and hungry and lonely. Human ingenuity discovered this and it was a human (if partly Caeliar) who explained the situation to the Gestalt. This doesn't excuse the Borg of their horiffically evil actions, but it reveals a better solution.
'it was they (the federation) who led the Caeliar'? Talk about unsubstantiated affirmations.How fortunate then that Picard wasn't our only hero here: although he broke, Captains Dax and Hernandez kept working to find solutions in the face of impossible, overwhelming odds, one of which destroyed 50% of the invasion and the other actually removed the Borg as a threat forever. The shadow did not, in the end, prevail although it looked like it was about to; even though the Federation didn't physically defeat the Borg, it was they who led the Caeliar to intervene and take responsibility for the Borg.
Hernandez, a Caeliar (by her own admission) - the half-divine being who attained full divinity in the end - informed the Caeliar that the borg were born because of them, and then the Caeliar, with no interference, decided to wave their wand and deal with the borg.
Where exactly is the federation leading anything?
Okay, so technically Hernandez wasn't a Federation citizen - but she was definitely a human, and a Captain of the Starfleet that helped pave the way for the Federation's formation. Let's also not forget Titan's part in this and the fact that their away team didn't repeat the mistakes Columbia's crew had hundreds of years earlier, which had an influence on Inyx. If Titan and co. hadn't convinced Hernandez to come with them, and later to work with the Gestalt after her and Dax's plan didn't work in its entirety, the Borg rampage would have consumed the Alpha and Beta Quadrants.
About the federation - Dax or the Da Vinci crew were the exceptions - and yes, they proved that the creative, the 'never give up' approach, would have worked.
But what about the rest of the federation?
Picard was the rule - broken, not even trying to find a solution, to prevail, because 'it won't work', reduced to trading soon-to-be useless weapon, waiting for the borg to snuff him. Most of starfleet behaved in this way, wanting only to commmit seppuku, the federation leadership had the same passive, defeatist behaviour.
The borg utterly broke Picard, his spirit, and the federation's - and all they had to do was show up.
Dax, da Vinci, Excalibur, Atlas, the Romulan Warbird whose name I can't recall that inspired a Federation planet to adopt a Romulan military haircut (and really, this should be highlighted... Federation ships sacrificing for Klingon colonies have become famous on Trek between Khitomer and Narendra III, but this was a Romulan warship dying for a Federation world), Martok, and a series of other vignettes throughout. Most of the rest of the Federation, while dying, wasn't going out hopelessly or helplessly - Picard and several admirals were the exception, not the rule. I think you're emphazing way too much Picard's personal defeat at the expense of Dax's "never say die" and Riker's more pessimistic but not hopeless outlook - and it was shocking, there's no doubt about it.
But the borg broke Picard long before they brought the big guns. Picard was a disappointment throughout the entire trilogy.
If that's true, then they also "broke" him three novels earlier, in Resistance, and very nearly did in First Contact. He's always had a blind spot for the Borg.
Indeed. And besides, so what if they did break him? Picard's not perfect, he has weaknesses too, and I think it was a good, if difficult, choice to show Picard finally breaking; he's been such a bastion of will and stoic carrying on that it becomes shocking but also sensible to see him reduced. Think of his breakdown at the end of "Family" and his rage in "First Contact;" now he's been dealing with a constant Borg presence and the Collective's voice in his head for, what, months?