I'm open to the argument that it's wrong/irrational, but I would wager that - at least in the USA - people wearing sunscreen are doing it to avoid skin cancer more than to avoid tanning.
"...skin cancer kills surprisingly few people: less than 3 per 100,000 in the U.S. each year. For every person who dies of skin cancer, more than 100 die from cardiovascular diseases."
Personally, I'm from the UK and don't worry about skin cancer. If I was in Australia or some climate I'm not adapted for then I'd be concerned.
kills surprisingly few people: less than 3 per 100,000
Yet the impact on quality of life is huge. Using the same US numbers [0], comparing directly-attributable deaths against life years lost (disability-adjusted life years):
Fair cancer impact comparisons. But the point was that increased sunshine can reduce cardiovascular issues so you'd need to look at incidents and impact for heart attack, stroke, etc.