On the performance of correlation consistent basis sets for the calculation of total atomization energies, geometries, and harmonic frequencies