I'm not sure whether it is a hard and fast rule, but that sentence to me should be:

Look at that small, red, fire hydrant

Looks like it's a fairly complicated and nuanced grammar rule:

https://style.mla.org/coordinate-adjectives-commas/