Project : Rooftop - Fan-Art Fridays featuring Cyclops. Check it out, there's a bunch of really fun drawings and redesigns of classic X-Man, Scott "Cyclops/Slim" Summers.
DC Comics character Snowflame is/was powered by Cocaine. For real. Not sure if he made it to the New 52 or not, but I don't see why you shouldn't petition DC to make it happen.
Daredevil villain with dissociative identity disorder - Typhoid Mary - Not exactly a redesign as she (in the Typhoid personality) seems like someone who would wear whatever she wants.
If you're interested in some real-life comics about real-life dissociative identity disorder, check out Madison Clell's book, Cuckoo HERE