Sister Psyche's death was such a copy of of how Jean Grey was going Dark Phoenix and Cyclops not wanting to kill her so she ended up doing it herself. Only in CoH, Manticore did what Cyclops refused to do and killed Sister Psyche.
If the game had continued, I wonder what would have happened to Manticore?
Know, thats kind of how I felt about it, in a way(though I watched the movie, :/). Honestly I'd have liked Manticore to remain a hero with a more jaded view, but i wasn't sure how the writer would have gone with that route. I notice manticores character development was rich boy who would do anything to win, kind of like green arrow, but kind of declining in a way. I noticed in general the freedom phalanxe was in a general decline, and considering the groups age, nothing to bad with that. Its a group that'd need to change if it wanted to succeed as any organization must in a changing environment. Heck, sister psyche and statesman dying were definite signs they'd need to.
In manticores case, he's a human at peak condition, but he'd be getting older and seeing more combat he'd be more worn, mentally from it. And having to kill sister psyche would certainly have been bad for his mind, i'd have rather a more gradual fall from grace for him if he was to become more of a vigilante, rather than the kind of semi-sudden falls from grace players in the vigilante and vigilante to villain missions took. I know time is always some kind of issue but, a gradual fall can be done.
Honestly though, I think it could probably be more interesting if he remained on the line as a hero, in a sense. But think of pushing him towards closer to a retirement range and a more skeptical kind of attitude. One could do quite a bit still. He hated killing sister psyche alot, perhaps he could be more hesitant in fighting and killing than he may have been. Or acting even more behind the scenes then he already was as a semi mastermind behind the scenes.
I actually am left wondering, where are the heroes who act purely behind the scenes in city of heroes? I am left wondering that somewhat, I could say Lady Grey may come close but Lady Grey is publicly the leader of Vanguard, more or less. Granted heroes generally react, villains act, but still. I just wonder, wheres the heroic equivilent of nemesis? The other close person is the letter wirter, Dream Doctor. I don't want to count Mender Silos as Mender Silos is, well, we know who he is/was.
If your wondering, I did have a character of that archtype in mind for my AE missions I was trying to make. I don't want to spoil who that was to be though

. Edit: Other than yeah there might be a character like that. It's a subject to change thing at this point since i'm purely on drawing board when I do ever decide to write, writers block keeping me stuck

.