It could be Johnny Depp, tattoos and partying...He’s been seen drunk in public a few times lately plus he got divorced, although the young girl he’s with now I assume wouldn’t have hooked up with him if she knew he had AIDs.
Depp would also has a better claim on being considered a “great actor” than many of the others listed. I doubt Charlie Sheen thinks he would be remembered as one.
Depp was my first guess. Charlie Sheen fits the bill only if you consider him a “megastar”.