Aside from the famous celebrities known specifically for their pipe habits, the idea of product placement is often lost to a changing non-smoking environment. Fantasy movies have done a great job at keeping piping alive, most people can't picture a wizard or leprechaun without. Yet it's almost sad that santa often seems to be a non smoker. I'd like to see a revival of pipers in prominent roles.
I am a huge fan of old movies. Especially the 30's and 40's. Ever since I got into pipe smoking I am suddenly seeing pipes in movies that I've watched dozens of times that I never noticed before. Not just secondary characters either. Sometimes the star is smoking a pipe for half the movie and I had never really taken note of it before. My pipe radar is on.
Now that the subject has been brought up, just watched Blade Runner a few days ago, hadn't seen it for years, but at the opening of the bar scene when Deckard is looking for Taffey Lewis, three people are smoking old fashioned clay pipes.
The best scene in an old movie revolving around the pipe has to be the final scene of The Big Shot (1937). I wish that I could find a clip.
As an aside, it was during my research of Inglorious Basterds that I came across the Falcon in Red Red Wine. And, of course, there is an iconic pipe-related scene in that movie.
(Don't ask how I got to UB40 from Tarrantino. Just accept the mystery.)
It turned out to be the 1942 movie of the same name with Bogey. I still might have the 1937 one. I will have to dig for it when I get home tonight. That one does not appear to be out on dvd.