I suspect that we'll get a Picard who is being tormented by memories of what the Borg did to him, waking up in cold sweats and the like, when Starfleet detects their presence once again. He'll initially be reluctant, but eventually agrees to help because he needs closure. Hey, I just described the plot of Aliens. There's almost no way that Kurtzman brings back Picard without also bringing back the Borg, IMO, since it's Picard's personal nemesis and Kurtzman is all about re-using things that were popular in past Trek.
I don't want to see the Borg again, but what really worries me is that we're going to end up with a Picard like the one in First Contact, which was a "much different" Picard than we saw in TNG, and not in a good way. That was less Captain Picard and more Captain Ahab renamed. When I say that I'm afraid that he'll be too different, that's what I mean. I don't mind seeing Picard in a different light, even broken--Chain of Command is one of the best of all of the TNG episodes--but there's a difference between seeing that for one or two episodes before getting back the character that we know and having a whole series of one, long story arc where an unhappy Picard is more or less the new baseline.