If Walt was Heisenberg all the time, maybe it would be appropriate to just label him a sociopath and be done with it. But that label ignores so much of the complexity of the character.
Walt does know right from wrong. He does care about certain people. He's not hesitant about using people, but he doesn't appear to take pleasure in it for its own sake. In the majority of situations, he does it with a specific purpose in mind which furthers his goals or protects the few people he does care about. That's not to say at all that he's right to do it, but it is NOT by any means typical behaviour of a sociopath.
He definitely has an ego and sometimes makes poor decisions because of it. (Sometimes they work out quite well, and of course make for awesome TV.) The Heisenberg part of him regards himself as superior to everyone else, while the Walt part has an inferiority complex that he's constantly trying to compensate for. That's why he didn't take the job at Grey Matter, or the buyout with Declan: pride and ego. Guess what? Lots of people make the same irrational choices every day. It's human.
After the last episode, it's pretty clear that Walt can't be redeemed. In that one episode alone, he hurt too many people he actually cares about in irreparable ways, which wasn't necessarily the case before that (well, as far as they knew... but now they know). He won't have a happy ending, for himself at least. But I would like to see him successfully complete his original mission: giving his family some financial security so they can go on without him. And in that way, I'm still totally rooting for him.