Comparison of single and double excitation coupled cluster and configuration interaction theories: determination of structure and equilibrium propertie