When the drug wore off and Roy came back to his senses, he fought Deathstroke out and vowed to redeem himself in Lian's honor by redeeming the Titans name that Slade diminished, deeming it something worth fighting for, as well as making amends with everyone he loved.
He decided to start and lead a new Titans team that would redeem the name, and he was joining the recently resurrected Jericho (Joey Wilson), his friend and fellow Titan.
During the Convergence storyline, Roy is living in Gotham, where he started a children's home and shelter, Lian's Place.
The villain Dreamslayer offered Roy a deal: that he would return Lian if Roy betrayed his friends Donna Troy and Starfire. Roy outsmarted him and managed to get Lian back without harming anyone, revealing that he had weaponized Gotham in case something like this ever happened. With that, Lian was back to life and Roy was reunited with his daughter once more."
It sounds like he's in an okay place. He found a new purpose, both when Lian's back and when not. In RHATO he started up imprisoned in Qurac for aiding a rebellion, but he won't do that if he has Lian and a children shelter.
Would Titans aid a rebellion against a dictator? Is that within their... no... DC heroes usually don't meddle in other country's politics unless there's a supervillain threat, right? A lone vigilante, yes, but not a well-known team like Titans.