For pure CD-ROM drives, LG had a really good thing going on with the 40x and faster ones. Excellent reliability, acceptable noise level, decent eject button (yeah, nitpicking, but a lot of drives have a small button that doesn't protrude very far from the faceplate...not good).
They actually OPEN when you tell them to, regardless of age. Gear-driven drives have a tendency to become one or two (or more) 'cogs' out of alignment which will cause them to jam when opening or closing, but I haven't had this happen with the LG drives (tbh not sure if they have a belt and pulleys or not, but I consider it a better design because it self-corrects for coming out of alignment)
DVD+/-RAM drive on my desktop is a Sony DRU-820A. Love that drive. Burns just about every pre-HD format there is quickly and reliably. Quietly...not so much, and I had to do some case modifications on my last case for the vent holes on it, but yeah. I like it quite a bit.
As far as old drives go, my favourite is an old 8x GoldStar (now LG) with the eject and stop buttons. Wish I had one handy to grab the model off of.
Also opens every time, very reliable. OS installs tend to go a bit slower because it's 8x, but I like it for reliability.