Best CD Burners:
Yamaha CRW-F1 (IDE or SCSI)
Plextor Premium II (IDE)
Plextor Premium (IDE)
Lite-On LTR-52327S (IDE)
Unfortunately, those are no longer being made, and can only be found on eBay.
The alternative is a DVD burner that burns CDs. No DVD burner is as good as a dedicated CD burner at burning CDs. Just keep that in mind. Of the drives available, the best would be:
Pioneer DVR-115D (IDE) or 215D (SATA)
Samsung SH-S203N (SATA)
Optiarc AD-7200A (IDE) or AD-7200S (SATA)
Unfortunately, even these drives are getting harder to find as some are no longer in current production. Once again, if you can't find them at a regular store, try eBay.
A few other choices for good CD burning DVD drives that would be eBay only:
BenQ DW1640 (IDE)
Plextor PX-760A (IDE)
Plextor PX-755SA (SATA)
Oh, and for the record, when it comes to CDs, the best burning drives are also the best ripping drives. The two things kind of go hand in hand.