Microstructure and rheology of soft to rigid shear-thickening colloidal suspensions