Ben Sisko: I feel Ben Sisko was character assassinated when he started taking this prophet thing too seriously and got way to caught up in the destiny thing. I wish he stayed on the skeptic/believer line.
Must respectfully disagree here. Ben Sisko was the character in Trek who evolved more than any other, thanks in part to his transition from skeptic to reluctant believer to genuine believer. I wouldn't have had him lose that.
Picard: I feel he had already made his peace with the Borg by the end of the series and he was even able to accept a one Hue a "reformed " borg, and then there was that whole Lore leading the Borg thing. He did not seem a bit traumatized or angered even being surrounded by them. He even tried to reason that Lore wasn't the answer to their independence. First Contact totally obliterated that in a rage by Picard, granted it's the only film from TNG sill worth watching more than once. I chalk it up with them probably wanting to compete with DS9.
"First Contact" seems to ignore both "I, Borg" and "Descent", restoring the Borg to their "Best of Both Worlds" state. Including Picard's issues with them.