Hi tarnationsauce2, welcome to CDFreaks!
Of the listed drives, the Sony NEC Optiarc AD-7170A ( = Sony AW-G170A) has excellent CD-R burn quality with Taiyo Yuden CD-R media.
In my experience there’s little to no quality control with these drives, so I can’t really recommend buying one unless you’re prepared to RMA (return) your drive if it doesn’t work.
These drives are also OK for DVD writing, but not spectacular.
The Pioneer DVR-111D is a very good DVD burner and it’s also a decent CD-R burner, but not as good for CD-R as the Sony NEC Optiarc drive in my experience.
I haven’t tested the latest generation of LiteOn DVD burners, but the previous generation is not very good for burning Taiyo Yuden CD-R media in my experience, so I’d be hesitant to chose one of those.
The LiteOn SOHR-5239V CD-RW drive is not a very good CD-R burner IMO, although it’s a very good reader. So I can’t recommend that for burning Audio CDs.
The best CD-RW burner on the market is probable the Plextor Premium and Plextor Premium2, but they are expensive and not listed on that site.
If I had to chose from that list I would get one of these:
NEC 7170A 18x DVD+/-RW Dual Layer Beige
NEC 7170A 18x DVD+/-RW Dual Layer Black
Sony Q170A 18x DVD+/-RW Dual Layer Black
But there’s a risk of getting a bad drive and having to RMA it.
These drives can perform quality scans of CD media, but they are quite temperamental scanners and have a tendency to show random C1/C2 spikes. I have found that the scanning speed is quite important and that 32x is least likely to produce random scanning spikes. For scanning DVDs these drives are IMO worse than useless - they are misleading! They are good for Read Transfer Tests of DVDs, however.