Not music, but in the late 90s or maybe early 2000s there was an anti-smoking PSA involving an old man encouraging a baby to take its first steps. After much encouragement, the baby starts walking, walks over to the old man, and passes right through him as he fades into partial transparency.

The message then rolls that you shouldn't smoke because your early death will deprive you of important moments like this one.

This PSA made far more of an impression than most do -- for example, it's mentioned on Friends -- and I think about it often as an example of how the same basic argument can be made in weak or strong terms. It may have been too strong for its own good; I once asked a friend for help finding a video of it and the response was "Oh, I know exactly the commercial you're talking about. I won't help you look for it; I hate that commercial and I don't want to see it again."

I never was able to find it.