My DH has a very classic name that was very popular at the time of his birth and has remained popular. PIL deliberately chose names for their DC that were popular 'so they wouldn't stand out'. DH was known as 'name initial' at school as there were quite a few others with the same name. It didn't bother him. He was a very shy child and says he would have hated a name which attracted attention and comment.
I have a relatively unusual name, although it's perfectly normal in Wales and is currently in the Welsh top 100, think Eleri. I grew up in England where my name is considered much more unusual. I was in my late 20s before I met someone else with my name and have yet to meet another. I like that I've only met one other with my name. I was a very shy child, like DH, but I liked that my name prompted comment as it helps kick start conversation. I also like that my name reflects my Welsh heritage.
The vast majority of comments have been nice 'oh that's so pretty, where's it from?'. Of course I get some rude comments, some people who decide 'oh I can't learn that, I'll call you Ellie instead'.
I think DH's family (and the English side of my own family) find it strange I like my name so much as so many people pronounce it wrong and the range of misspellings I get are truly spectacular. I think they also get comments from other people about it if they mention me by name.
One relative suggested I change it to something English so people wouldn't wonder about my background!
There are lots of lovely names out there outside of the top 100/500/1000 which are from other cultures, or are names which are simply not used a lot at the moment. There's a big range between a name like Juliet (currently ranked 777) or even an old name only used a handful of times each year, like Morwenna, and something truly unique.
I would prefer a Welsh name for any DC, and most will be unusual in England to a degree. If I didn't use a Welsh name I would prefer a name that wasn't super popular. I wouldn't name a child something unusual if I didn't like the name. I can't imagine many people do that, similarly I imagine most people who give their DC a top 10 name do so because they like the name and don't pick a name they don't like just because it's popular.
Ultimately there is no way of knowing if your child will be like my DH and will like having a popular name or if they will be like me and like having something a bit more unusual. You just have to pick something you like that you think won't truly embarrass the child (e.g. Tallulah does the hula) and hope they like it too.