With our DD, I wanted a really unusual name. DH wanted something really popular. We went with something in the middle. It's unusual for her age group, but is an established name which most people from lots of different countries recognise, can spell and pronounce easily. We have a bit of a mix of cultures in our families and are likely to live abroad at some point, so it was important it worked in other cultures.
Tbh, I was a bit miffed at first that I didn't get my more 'out there' choice, but it was the right compromise for us. I haven't met a baby with the same name yet and, realistically, I think I might have cringed saying the 'out there' name aloud for a little while. It also could have ended up being a pain in the arse to spell out all the time if we moved abroad.
We are now TTC DC2 and I would now go for a similar, not too popular, but well known name over anything really unusual. I certainly wouldn't set out to find an unusual name, as Sod's law says that the minute I did that, it would become hugely popular anyway
.
If both you and your DP love a name which happens to be unusual over anything else, then go for it. If you only like it because it's unusual, then I probably wouldn't. You have no idea if your DC will share your enthusiasm for its unusual-ness. Or, they could get to school and there would be several in the class with the same name. That's no problem if you really love the name anyway, but would be annoying if you only love it because it's unusual iyswim.