I’ve always been a fan of the ‘worst person becomes the hero’ trope.

See ‘Incorruptible’ comic

And yes, Red Sun may be the best Superman comic ever written.