ATA_CAM makes all of your ATA devices available through cam, but has no effect on the actual underlying driver.
ahci provides proper SATA support (along with NCQ, so ostensibly speeding things up a bit) & puts your SATA devices under cam, but it has no effect on any other (non-serial) ATA...