I do not think that we get to the point that you would have to take pills as a preventative for each possible cancer, there probably are some commonalities. Moreover, when such pills may be available, so would be genetic testing/metabolic profiling to allow a individualized selection for the cancer that are most likely in a given individual.
Many people already take daily vitamins and other supplements, I see little difference with this. For that matter how many people are taking their daily aspirin? What about vitamin D? I see absolutely no psychological issues with this. Taking a baby aspirin does not remind me that I am getting a heart attack, quite the opposite actually.
M