Theory And Phenomenology Of Flavorful Two Higgs Doublet Models