Well, it’s a matter of perspective. Julia would say that Titus is intent on undermining Augusta and weakening her sense of self, since Titus is ‘weak’, interacting with him increases Augusta’s Paragon stat, and otherwise makes her less likely to follow her mother’s example. On the other hand, Titus might say that we are robbing her of her childhood, destroying her natural passions in favor of what is best for the state, and shaping her into an Empress, which is a category of women with whom Titus has not had particularly pleasant interactions and who have quite literally destroyed themselves over the last half century or so. And given the history of the Imperial court, is Titus not right to suspect that we’re turning his family against him? We can actually do that with Augusta, should we so desire. He knows when we do, because it raises his anger statistic.
I don’t think Titus is a hero. He certainly has little desire to save Iudia or anything like that. He’s focused on one person, and not very good at doing so. He’s naive, gullible, petty and guileless. But in a game where every other character has some sort of ulterior motive and layered scheme to increase their own power, his only interest is in Augusta and Julia (the latter at least until he potentially accepts her lack of affection).
Sure, you could argue valuing his daughter’s superficial happiness instead of realizing her precarious position and working to ensure her survival is short-sighted. Refusing to work with potential allies due to decade old jealousies is more short-sighted. And being cajoled into destroying his daughter’s life over anger is the most short-sighted thing in this story so far. But he, in a naively genuine way, doesn’t mean any harm to, well, anyone. He think’s saving Augusta through all of his actions. He even plans to spare us and allow us to leave the city, and that’s more than I can say for what his wife would do. He’s more beneficent, albeit in a bumbling way, than Consentia, Antonius, Ceto, Leta, Darius, Julia, or potentially even Augusta herself in a Tyrant run. As we can remark in the game, perhaps it is best that he was not in the capital for so long, because someone so open and unguarded would not last very long.
That being said, how much you value his vaguely well-meaning genuineness versus his sheer incompetence is personal preference! His inability to accept the Prefect and grasp the situation at hand certainly makes him grating at times.