I have to agree with the other posters that I have to like the name first and foremost, and the good association might be the difference between it making the short list as well as the long list. I have [name_f]Hermione[/name_f] as a middle because the name in itself is gorgeous but also because I have a deep connection to the name through [name_m]Harry[/name_m] [name_m]Potter[/name_m]. I did grow up in the HP generation and to me, [name_f]Hermione[/name_f] [name_m]Granger[/name_m] was a role model. I would love to pass on a bit of my childhood to one of my kids.
I have some names which I loved and then made a connection to so some I admired, which just became an added bonus but not the main thing influencing me. I think it should always be the name before the positive association.
I would love to use names based off of literature or musicians, but I either don’t like the names or they’re unusable. My favorite book series is The [name_u]Legend[/name_u] of Drizzt, but I’ll never use Drizzt. I’ve added Jarlaxle(a character from the books) but I’m not sure I’ll use it.
I think pop culture exposes us to new names that we may not have come across otherwise, which is pretty cool. Personally, I’d never name a kid after someone just because I admire them. But if I liked the name, it’s like a bonus that it honors someone I really look up to.
Same goes for family names.
Never ever ever ever 
Only if I really like the name but it wouldn’t be because I admire them.
I’ve grown to love so many of my names because I heard it from a celebrity or fictional character, and if I happen to love that celebrity/character, it’s an added bonus. Most of the time, I stop assocating it with them if I like it enough and start liking it on it’s own, so the celebrity or character is only inspiration. But if I didn’t like the name, I wouldn’t use it, even if I liked the character.