Bond, James Bond.
Works for the new movie, except I didn't see much of the "sympathy" or "moral code" bits.
Also not a super-hero.
A) Per 'Moral Code': Refusing to abandon the maternal figure, M, to die but willing to leave any fellow agent behind, strangely, and for no conceivable reason trying to rescue, and lamenting the death of a converted sex-slave/assassin/concubine from the evil mastermind..Imjussaying...
B) Not a super-hero? Not a super-hero??? He's got more gadgets than Batman, he's seemingly indestructible, and he has an origin story!