Trent, while I understand what you're saying, I thoroughly disagree with some of the values that underlie your evaluation of the trilogy. The Borg invasion didn't constitute failure, because failure implies that there was ever a real possibility of success on the primary characters' own merits. But the Borg have always been so powerful as to render our heroes powerless when faced with power of such magnitude.
It's not only that the characters failed to stop the borg; it's that they didn't even try - that was their failure.
Between Picard's passivity, La Forge's (and others) so-called "moral" arguments, the fact that many personages thought a psychotherapy session was more important than actually trying to save the Federation and the rest of the alpha and beta quadrants and the ending when the situation was saved by "God", I agree with Trent
that the "destiny" trilogy betrays the optimism and confidence in one's abilities that used to characterise Star Trek.