TBH I've never seen an IDE optical drive without the 4-pin redbook audio connector, but who's questioning their existence? I know for a fact that SATA drives don't have it and neither do the SATA-to-IDE adapters, so going for a native IDE optical drive is your best bet if you find redbook audio important.
As far as my opinion on certain brands goes: No-name ones should be avoided, I had a couple no-name/generic DVD-ROM drives from the early-2000s and none of them worked properly. Wearnes is one bad brand because their drives are known for not being able to read burnt CDs (which can be important in some cases), I have an 8x Wearnes CD-ROM drive and it could never read CD-Rs nor CD-RWs even when it still worked (Compaq used Wearnes drives quite often). The only major brand I've had issues with was HL-DT-ST which typically had trouble burning discs, but since this is about DOS PCs which won't be doing any burning, you should be OK with their drives.
Warlord wrote:The drives that I have had the worst luck with and seen the most failures from are Sony drives and this is multiple occasions. That being said I don't even think that sony and for that matter a lot of other companies manufactured their own drives, they only did firmware and stickers.
Haven't had problems with Sony drives either, then again the quality of their products in general have gone downhill ever since they cut corners by relying on average Chinese manufacturers like everybody else, so it's possible that the good Sony drives predate this generation (the newest one I have is from 2006).
creepingnet wrote:Anything 8086/80186/80188/8088 should not have a CD-ROM, not like it's really all that useful, and if I want to listen to tunes with the 8088, spinning some LPs on the turntable makes more sense anyway for a more authentic early 80's experience.
There's also listening to some good ol' fashioned cassettes on a cassette deck/boombox. 😎