Naming your baby a popular name, would you or would you not?

jess
What are your opinions on naming your baby a name that is on the top 100, or even the top 10 list? Would you or would you not? 
For me - I've adored the name Sophie since I was younger and always wanted to name one of my little girls that. Now it seems to be such a popular name. Hub and I would name her Sophie James to give her a little uniqueness (James is a family name so that would be her middle). I love it but I worry that "Sophia" is too overused - even though I would be doing soph-ie. I'm torn. 
What do you think and do you have a similar situation? Or have in the past? comment below with your thoughts/experience with this!