NASA are using a CMOS camera on their Parker Solar Probe.
I and others use them for spectroscopy without any issues. As with CCD you need to check the linearity etc.
You also need to set the gain and offset to suit. You effectively can trade off read noise for dynamic range.