Surprised no one's mentioned the Joker yet. But I guess it goes without saying.
EDIT: Sylvia Christel from No More Heroes. Not in your face insane, but there's something incredibly off putting about her, at least to me.
I wanted to and mention a lot of the others from Arkham City and Asylum but then I'd probably end up being here forever or longer than I should be.