It actually looks very strange to me, unbalanced, like something (a second comma) is missing. In context it might make sense, with different emphasis on the adjectives, but I certainly wouldn't recommend that as the default pattern. It looks a bit like you made a longer expression (adding a third to an expression already with two adjectives) and then got a bit confused about punctuation, and added the comma to make it look less awkward without really thinking about the whole structure.
Certainly we can get a structure like that, maybe something like yelling, screaming small children where "yelling" and "screaming" are in a different relationship to "children" than "small" (they're the yelling and screaming kind of small children), but that's an exception, not the rule.
As a simple rule, most of the time a comma should be a substitute for "and", so try replacing it:
Yelling and screaming small children (OK)
short and straight brown hair (maybe OK, a little awkward)