"SCSI" is an umbrella term for a system of related, layered protocols and definitions. SCSI specifies everything from the physical dimensions of the connectors and cables, the electrical voltages and currents on the wire, the clocking mechanism, the protocol on the wire, to the commands that devices understand.
Obviously, the connectors, cables, electrical specifications, and wire protocols are obsolete nowadays, and have been for a long time.
The commands, however, live on. An Operating System doesn't care about the size of the plug or the voltage on the wire or how data is encoded on the wire, it only cares about the commands it sends to the devices. So, as long as a device "understands" the SCSI commands, from the OS's perspective, it is a SCSI device. The OS doesn't know how the device is connected to the system, it only knows the "language" the device speaks.
SCSI has always been the "more professional", "more powerful", "more mature" alternative compared to its competitors (most notably ATA), so it makes sense that lots of newer technologies simply adopt the SCSI commands instead of going through the trouble of creating their own.
The first CD drives which were introduced were insanely expensive and intended for Unix workstations, so naturally, they were SCSI drives. When the first ATA CD drives came out, instead of re-inventing everything the SCSI guys had done, the ATA guys invented ATAPI, the ATA Packet Interface, which is nothing but a way of tunneling SCSI commands through ATA.
When ATA hard disks gained more "professional" features such as self-monitoring, encryption, command queueing, the ATA guys did not go off into the woods and did their own thing, they took heavy inspiration from the SCSI features.
When Firewire was introduced, they chose to use SCSI commands for external drives. When USB was introduced, they did the same.
Interestingly, there has also been technology transfer in the other direction: the SAS protocol and the electrical and physical wiring is heavily based on SATA.
When CD-ROMs were introduced into Linux, they were based on the SCSI subsystem, which led to the interesting state that a hard disk and a CD-ROM connected to the very same cable would show up in two different subsystems.
When USB and Firewire were introduced, naturally, they used the SCSI subsystem.
So, when SATA was introduced into the Linux kernel, it was decided to base it on the much cleaner and much better implemented SCSI subsystem rather than the old and crufty ATA subsystem.
And at some point, it was decided to move PATA hard disks to the SCSI subsystem as well.
Why does the Linux SCSI subsystem drive hardware not obviously related to SCSI?
To steal the comment under the question: because they are related to SCSI, just in a non-obvious way.
They all use the SCSI commands, which from the perspective of the OS, is the only thing that's relevant.
Why aren't NVMe and (historically) PATA support part of the SCSI subsystem?
NVMe is specifically designed to be unlike traditional storage command APIs because flash memory is very unlike traditional rotating hard disks or tapes.
For PATA, it is historical. I wouldn't be surprised if the real reason is simply that Linus's computer in 1991 didn't have a SCSI disk, so the PATA subsystem came first. After SATA support was introduced, PATA was indeed moved to the SCSI subsystem.