I like your term "classy arrangement" because yes I would definitely consider the professional needle method as much more classy than the gun.
And yes, you sum up the sound of the gun right. It is not terrifying nor will it cause nightmares but it is not pleasant and although one knows it is coming it is a little startling if it is your first time with the gun but nothing major. The sound alone is not what should put one off from the gun.
But to answer your last question, my piercing days are over. I have no desire to ever get my ears pierced again and because of my experience with infections, I hope my daughter never wants to get her ears pierced. I will not encourage her in any way, but if a day comes where she says she wants them pierced and I cannot convince her otherwise, then I will seek a professional to do it with a needle.