The son of the late Captain Benjamin Sisko, Jake represents a past and future that was molded by Jean-Luc Picard. It was Picard who was responsible for the father of Jake’s depression and the death of Jake’s mother at the hands of the Borg. Picard, having been brought into the Borg as Locutus was widely viewed as the reason for the Battle of Wolf 359, which was where Jake’s mother Jennifer would die. In her family’s quarters as debris fell on top of her.
Jake, only 11 at the time, was sad more than anything. Though with the help of the Deep Space 9 crew, his father and his best friend Nog, Jake recovered emotionally and became a journalist. His father, however, would fall at the hands of Gul Dukat in the series finale of DS9, leaving Jake an orphan. With the actor who played Nog being deceased, there’s no way one could bring Nog back into the universe without upsetting fans. Meaning that Jake Sisko could be truly alone.
So it’s entirely possible that Jake is lonely and angry at what Star Fleet has taken from him. He could be out for revenge or possibly just broken and bitter like Picard. Even better, perhaps Jake Sisko becomes a galaxy renowned reporter and is trying to uncover some big Star Fleet conspiracy. Whichever way the show would take him, the one thing is for sure is that Jake has to hold resentment for Picard, even if it’s just a simmer compared to his fathers. His father could not stand Picard, and while one could argue that he eventually let go of that animosity later in the Deep Space 9 series, that type of hate is hard to chill. He’d more or less be a proxy stand-in for his father, chastizing Picard for still being the same arrogant man he was thirty-odd years earlier.
That dynamic would be wonderful television.