If you can't imagine a Kennedy or a character on 1950s US TV having the name, don't use it. Having a "special" name is unlikely to bring any benefit, and may well have significant social costs (plus having always to repeat yourself and spell your name, correcting misspellings on forms, et c.)
With my three young kids I already regret the very, very slightly unusual name we used for the first one (ordinary spelling for the name, name has a long history but it's almost homophonic with a 20x more common name, which we should have just used instead). Just don't do it.
Even as a professional working for a small business, I get re-introduced over and over again to the same people. I'm sure that my words and appearance play a role in that as well, but surely my name is not helping.