Wow, there are a lot of bad explanations in that thread. A lot of it seems to stem from people not making the distinction between SCSI commands and lower-level transports, many of which also have SCSI in their names. But that seems to be pretty common in storage, where the separation of layers isn't as clear as on the Internet.
This is because SCSI is harder to implement, but SCSI is more flexible, and ATA was not flexible enough to support first CD drives.<p>So with first "civilian" CD drives, appear few proprietary interfaces and some used sort of SCSI.<p>Than just made decision, to save resources, make hybrid, using ATA electronics, but partially SCSI logic/software.
> SATA HDDs nor CD drives talk any AHCI.<p>I bought a used HP EliteDesk Mini G1 off eBay to replace a Raspberry Pi for a project. It requires a SATA m.2 which needs an AHCI controller on-board. Very difficult to find.