From addiction to overdoses, these are the narcotics that tragically brought down many famous artists.