Theory and Phenomenology of CP-conserving Two-Higgs-doublet Models with Flavor-aligned and Four-texture Yukawa Couplings