To be honest Frank never really worked as a character in the Marvel universe. Yes granted it is comics and all that so disbelief is needed. But in a world full of heroes who value human life so much that they want even the average citizen held accountable for even accidental deaths they have no problem teaming up with a man who has murdered hundreds and hundreds of people. (Its okay because when he hung with Spidey he used rubber bullets
In Civil War he murdered a couple villains in plain view of Captain America and other heroes, yet these group of masked crime fighters who were in a war to defend civil rights and all of that did not turn a man in for executing two people unarmed people who were just standing there. Yes Captain America beat him up but he was not held legally accountable.
Punisher really only works in the Max series where there are no other heroes.