Showing someone (or another dog) that you're excited or scared ("tail between his legs") is a very potent social mechanism I think. I don't think it adds much to the motor skills of the dog, besides maybe giving it a tool to keep flies and insects away from the ol' pooper.