I guess I'm going to go out on a limb here and say yes, which is ironic because when I read the topic I thought it would be overflowing with responses in the yes camp.
First, let's look at it objectively. I googled 'list of the greatest novels' (hows that for impartial research?) and clicked on the first one I found. Just in the top 10, I found works by Joyce (family struggled with poverty at times, he also had a tendency to alcoholism) Fitzgerald (also, an alcoholic) Nabokov(had to deal with political unrest, synesthesia, problems in his family) Huxley ( I won't pass judgment on his drug use, but you get the idea) Faulkner (adulterer, alcholic) ... the list goes on.
Obviously, correlation does not imply causation, and increased scrutiny of these individuals may reveal seeming causes of personal distress, while their subjective measure of well being may have been unaffected. But when you think about all the greatest artists, they almost always have some degree of personal suffering associated with him (happy artists, after all, don't cut off their ears or meet their demise staring down a shotgun.)
Think about it another way; the Brady Bunch might be a great show (I mean, somebody might think it's a great show...) but is it a masterpiece of film? The number one movie on imdb's top 250 is the godfather, and is in the company of schindler's list and one flew over the cuckoo's nest. Cheery tales, all. Strangely, happy feet isn't on the list, and Shrek doesn't appear until #211. People, in general, tend to view a work of art that features suffering, as superior, as it's an emotion to which we can all very easily relate, and the artist's ability to recreate emotion is an often used measure of a work of art's effectiveness. (And if we can't relate to suffering readily, we have bigger problems than being unable to appreciate art.)
Does that mean that the author has to suffer in order to be able to create a true masterpiece? No, not strictly. But they do say 'write what you know.' And no matter how good of an imagination you have, it's no substitute for the real experience.