Assessing combinations of singlet-paired coupled cluster and density functional theory for treating electron correlation in closed and open shells