Success is the balance of dissatisfaction with your own work combined with a drive to push forward. The drive without the dissatisfaction just leads to a bunch of mediocre half done projects, the dissatisfaction without the drive will just end in depression.
I think truly great people are nearly torn apart by these clashing drives, but that's what leads to true masterpieces.
On a personal note I think it's important to find the level of dissatisfaction that works best for you. It my be great to make Thriller, but paradoxically if you're the person that makes Thriller you won't be able to accept its greatness. At the same time you never want to be in a state of comfort such that your life is spent playing xbox all day. Of course some (Buddhists being one group) would argue that true happiness is elimination of both the drive and the dissatisfaction, they may be right but I'm too driven in my personal work to follow that path ;)
It's unclear whether you're talking about Thriller itself or about Bad, but Thriller was definitely driven by dissatisfaction with himself (he was extremely lonely according to his bios) and with the world at large: Jackson was frustrated by Off The Wall not having gotten Album of the Year (and felt it was unfair), and he was annoyed that the music industry and its press did not care about black people in general and him in particular (e.g. in 1980 Rolling Stone refused to do a cover story on him).
How many times have you finished a program but known it could be better, if only you had more time? A little optimization here, some refactoring there... The necessities of producing actual works prevent us from ever giving them the degree of polish we feel they deserve.
Slashdot once interviewed The Filthy Critic, and he talked about a friend who had spent time in the writing rooms of a few sitcoms. The writers working on shows that were really pretty poor thought their work was hilarious. They couldn't get enough of their own jokes. He contrasted it with The Simpsons's writing room: full of frustrated, self-loathing writers who didn't think what they were doing was any good at all.
"The trick is to realize that there's no real contradiction here. You want to be optimistic and skeptical about two different things. You have to be optimistic about the possibility of solving the problem, but skeptical about the value of whatever solution you've got so far.
People who do good work often think that whatever they're working on is no good. Others see what they've done and are full of wonder, but the creator is full of worry. This pattern is no coincidence: it is the worry that made the work good.
If you can keep hope and worry balanced, they will drive a project forward the same way your two legs drive a bicycle forward. In the first phase of the two-cycle innovation engine, you work furiously on some problem, inspired by your confidence that you'll be able to solve it. In the second phase, you look at what you've done in the cold light of morning, and see all its flaws very clearly. But as long as your critical spirit doesn't outweigh your hope, you'll be able to look at your admittedly incomplete system, and think, how hard can it be to get the rest of the way?, thereby continuing the cycle."
-Paul Graham