This may be a stupid question, but why even consider buying a CDROM when a DVDROM isn't much more expensive and more compatible then a CDROM?
You might want to consider a Toshiba (1912-series) or Aopen 1648 DVDROM. These are both pretty quiet, offer very good compatibility and tolerance etc etc. I especially like the Aopen drive.
And, if it's still too noisy, there's always an option of slowing it down a little, resulting in a lower noise production (but of course, some lower transfers as well).