Sherlock's on here, and that's good, but how about including this exchange:

"MORIARTY: Sherlock, your big brother and all the King's horses couldn't make me do a thing I didn't want to. HOLMES: Yes, but I'm not my brother, remember? I am you. Prepared to do anything. Prepared to burn. Prepared to do what ordinary people won't do. You want me to shake hands with you in hell? I shall not disappoint you. MORIARTY: Nah — you talk big. Nah... you're ordinary. You're ordinary — you're on the side of the angels. HOLMES: Oh, I may be on the side of the angels... but don't think for one second that I am one of them."

Very to the point, the last line is the definition of the trope, almost verbatim.

Should Belkar be on this page, given that he is also the illustrating example of Heroic Comedic Sociopath?