Higher fat content in milk generally results in creamier, more stable foam, while lower fat milk produces lighter, airier foam.