I have a tendency to crush on blond punks and bass players. It doesn't help that he's both. Lol.
It's the same with Duff's bandmate, Axl Rose. Most of Axl's personal planets are conjunct my IC/NN. He happened to be born during that Aquarius stellium during the sixties. I also have a NN/SN conjunction double whammy with Mr. Rose as well. With him, it's a repulsion/fascination. How would the particular energy of both Mr. McKagan and Mr. Rose be essential to my core being? Also if you find links that explain it, I would love to read it.
I would study the meaning of your NN and SN axis. Look up meanings for NN in Aquarius, but also in 4H. Some authors use the same interpretation for signs and houses, but it is different, so look up both. I can't think of any links off the top of my head, but there's so much out there, including books. Just keep reading until you find those that resonate with you. Also look at what the ruler of your NN is doing. In your case, understanding the MC/IC axis will be important too.