Pipes are cool when you're old, and cigars are for when you're young. Supposedly. Some cigars can be well naff, but if they're actually from Cuba it's not so bad.

It's a long way off before you can know for sure. He's just been born, after all. You'll be in your twenties when he starts at Hogwarts, though, so I don't know how he could see you as anything but utterly snitch. His parents will be absolutely ancient by comparison.

My Father can regale you with plenty of tantrum stories (mind, he has a tendency to see an even slightly pouty lip as a tantrum), but mostly, I'm surprised you can't think of any you witnessed yourself. Seven year olds don't have much of a sense of dignity, you know.