I've just finished reading the following two books which I believe give the maximum insight into why we do what we do. Although these aren't trading psychology text books I believe that they will explain why you sometimes behave irrationally and take "bad" trades when you know that you shouldn't.

Both books are by Daniel Goleman.
Emotional Intelligence: Why It Can Matter More Than IQ
Working with Emotional Intelligence