CD audio connectors
The MPC-2 connector is the most recent standard, used by most drives since the late 1990s. It uses a Molex 70107 connector, which has standard 2.54mm spacing so it can mate with the older 4-pin Dupont connectors. In addition it has a locking clip to prevent the connector from working its way loose.
The pinout is R-G-G-L, with R being pin 1.
This is a standard type of PCB connector, having been used to connect the PC speaker since the very first PCs. It is physically compatible with the later MPC standard, however the signal lines are not standardised. Many were R-G-G-L so are compatible with MPC, but there are likely to be other versions that use R-G-L-G which was another common layout.
For this reason when specifying a 4-pin Dupont connector, it should be listed as 4-pin Dupont RGGL to avoid ambiguity.
SoundBlaster CD audio
This tiny connector looks similar to JST but is slightly smaller and was used on Creative Labs sound cards as the earliest CD audio connector.
The pinout for this connector is O-L-G-R, with R being pin 4. (O is Open, or "not connected".)
Apparently the connector changes on AWE64 cards, and becomes L-O-G-R, as if the MPC pin layout was used by accident.
Sony CD audio
The Sony cable looks very similar to a floppy power (Berg) connector, but it has different keying pins.
Texel CD audio
Toshiba CD audio
NEC CD audio
Mitsumi CD audio