Any drive will be capable of ripping just fine. If you really want to get into the nitty gritty finding a drive with well known read offsets and the ability to defeat the drive cache is a good bet so you can compare against the accuraterip database.
Not all CD-ROM drives, even those that can play audio, can be used to rip digital audio. Some only have an analogue audio output for playing CDs. I know at least some IDE CD-ROM drives can't read digital audio.
It might be true that all SATA drives can read digital audio.