This entirely depends on what image you want to give the character, if it is a realistic book or a fantasy, if it's a historical novel (
Scarlett practically didn't exist as a given name before "Gone With the Wind"), what the character's class background is, etc. There would be many characters for whom
Scarlett could be an excellent choice, and many for whom it would be quite an unwise choice.