The role of nonmetricity in metric-affine theories of gravity