In Hollywood, a scandal is often seen as the end of a career. But for some celebrities, controversy had the opposite effect.