One of the better investment books around is exactly about that.
A personal favourite was when Stanley Druckenmiller got himself involved in Tech stocks at the top of the dot-com bubble.
“Druckenmiller knew exactly what he was doing – he just couldn’t stop himself. ‘I bought $6 billion worth of tech stocks, and in six weeks I had lost $3 billion in that one play. You asked me what I learned. I didn’t learn anything. I already knew that I wasn’t supposed to do that. I was just an emotional basketcase and couldn’t help myself. So maybe I learned not to do it again, but I already knew that.‘”