Maybe when they achive fame, and it doesn't make them happy, maybe that's when they fall apart.

I think that's a valid point actually. Many people who have a self-destructive bent crave love and approval, because they don't love themselves, and fame/fortune would seem to be the answer to it.

However their issues are entirely internal so fame/fortune will only serve to amplify those problems, rather than fixing them. The individual often can't/won't address their inner demons so ends up back on the road to self-destruction, only this time with a fortune to help them achieve it and fame enough that the media will be all too happy to push them along.