Obviously all you're going to get when you post on here is personal feelings - no hard and fast facts as which is the best way to go, and so all you can do is work out which best aligns with your thoughts on the matter.
Some people love being a generic Sophie Jones or Emma Smith, while others can't think of anything more mundane.
It is worth pointing out there is scads of middle ground between a super-popular, dull, tired, over-used name, and an usual, unheard-of, yoonee'q name. And this is probably where you want to focus your hunt on.
Personally? I avoided very popular names, because I didn't really want my kids to have the Karen, Joanne, Claire, Jennifer names of this generation. Absolutely nothing wrong with those names - all nice, but now a bit dull through sheer over-use 30 years ago.
And the one comment that always make me a bit
is, 'popular names are popular because they're lovely'. It doesn't make any logical sense. If that were the case, then the same names would be popular all the time, rather than being popular for a set period of time and then falling from favour. If names are 'popular because they're lovely', then why isn't everyone still calling their daughters Claire and Jennifer?
Names are popular because they're fashionable and because the style of the name is part of the zeitgeist of the time. At the moment, quite feminine, frilly names are popular (for girls, anyway!); often ending in -a or -y/ie. Whereas back in our generation it was quite a different style of name tha was predominantly around, often ending in a consonant; Karen, Joanne, etc - definitely a far less frilly style.
It wont be too long - in fact , it's already happening - before people start to move away from the more overtly feminine styles that are popular at the moment.
The issue with choosing a popular, top-10 name is that it will date. It will be associated with a certain era.
And some names date better/worse than others. Some name date because they're cyclical (classic names, but they come in and out of fashion, i.e. Isabelle/Isobel) and some date because they're totally of-the-moment, used once, never to be used again - Jayden, Neveah, etc.
Some names date, because they capture the popular imagination - wrong place, wrong time, type thing - e.g. Sharon and Tracey.
There's no way of foretelling quite which way a name's going to go.
But the bottom line is that there are zillions and zillions of names out there that are not being used by everyone, that are not massively popular, won't end up being associated with a certain era, and won't inevitably sound dated in another generation.
And this is why many people avoid popular names.