Seeing Bruce Wayne, Captain America, Professor Xavier, Tony Stark/Iron Man and Nick Fury smoke their pipes is pretty awesome every time I see it. I've already seen them smoke pipes before in old comics, with the exception of Steve Rogers/Captain America. I was tickled to see that, so thanks! Even though he's probably the most famous cigar smoker in comics, I do recall an issue of either Wolverine or X-Men where Logan is smoking a pipe.
Popeye, of course, and without a doubt, is the most popular cartoon pipe-smoker of all time. OF ALL TIME. A Popeye without his corn cob pipe would be a horrific sin!
James Gordon, Gotham City's Top Cop and ally of Batman still smokes his pipe - in Batman: Arkham Asylum (the second-best superhero video game ever, topped only by Batman: Arkham City) drops his pipe after being kidnapped by the Joker's goons. Batman finds the pipe, knows that Gordon would never willingly let go of his favorite pipe (a gift from his daughter Barbara) and uses the composition of the tobacco to follow Gordon. How cool is that? NANA-NANA-NANA-NANA-BATMAN!!