Systematic study of longitudinal and transverse helicity amplitudes in the hypercentral Constituent Quark Model