Enhancement and interplay of first- and second-order spatial dispersion in metamaterials with moderate-permittivity inclusions