Unpacking the Boundary Conditions and Heterogeneous Effects of Homophily