It has to be natural and fitting to reality and believable.
If done poorly it can border on vaudevillian or "skit"ish (like a Carol Burnett skit portraying a southern belle where it's comical instead of believable. Or Mama's house or whatever Vicki Lawrence's over the top grandma character portrayal is).