Two-quasiparticle excitations and collectivity in the weakly-deformed transitional isotopes 104, 106, 108Cd