Pioneer DVR-115 series and Optiarc AD-7200A series are just about the best drives I have for most media, with Pioneer DVR-112 series (not on the ballot) being just as good.
My older scanning drives weren't mentioned and are no longer available (LiteOn SHM-165P6S, BenQ DW1655, Plextor PX-760A).
I guess I should update my signature...
Pioneer DVR-112L, LiteOn SHM-165P6S, Pioneer DVR-111L, BenQ DW1655, Plextor PX-760A
LiteOn LH-20A1P, Optiarc AD-7203A, Matshita UJ-840S, Sony RDR-HX910, Sony RDR-HX750