Comment by Lammy
If you just want to rip audio CDs, pretty much any USB drive ever made will be fine. If you want a drive that can do everything up to and including UHD BD, try a Pioneer BDR-XS07UHD if you like slot loading or a Pioneer BDR-XD07B if you need a top-loader with snap-spindle for mini CDs or oddly-shaped CDs. These will cost way more than an old USB2-era drive but will be brand new.
You might be able to trawl your local thrift store and walk out with a $5 external drive from the 2000s, but a drive like that should be opened, dusted out, lens cleaned, and rails lubricated with some PTFE grease: https://www.amazon.com/dp/B0081JE0OO
Exact Audio Copy is still the gold standard for ripping software, and here's how to configure it: https://zexwoo.blog/en/posts/tutorials/eac-ripping/
Or XLD if you're on Mac: https://zexwoo.blog/en/posts/tutorials/xld-ripping/
> pretty much any USB drive ever made will be fine.
This is not the case. Most of the cheap drives on Amazon sold by random capital letters people are complete shit. As an example, the "CB31005" drive doesn't fucking work. It often gets hung up on reading the TOC and won't even admit there is a CD in the drive. If it doesn't hang there, it reads fine for a while, then at some random point (possibly the first point of error) just gives up and fails to read sectors, forevermore, until you unplug and replug the drive.
Even with EAC (which is indeed very good), it just spends hours re-reading sectors up to its maximum number of retries, giving up, and inserting silence. Do not buy a CB31005.