I went the cheap route with my CD-ROM drive.  I use a Philips CM 205 which is
single speed and costed under $80.  Mine works fine in Warp, DOS, or Windows.
I like it since it has an external volume control and stereo plug that I hook
into a Sony CFS-1030 boombox.  It has two external RCA outputs that I can
route to my sound card input but the signal noise is too extreme.

The Warp manual has info about adding Philips CM 205 and 206 CD-ROM drives,
Sony, Mitsumi, or Hitachi CD-ROM drives, and Sound Blaster CD-ROM drives.

I can't really advise anyone on a fast CD-ROM drive.  But I'd recommend the
Philips models (they invented the technology).  CD-ROM drives will soon (a
year) double in density and the "faster" models nowadays are not worth the
temporary investment to me.  You'll find that much of the speedup comes from
onboard memory used as a cache.  But Warp can cache a CD-ROM drive and I
rarely run a program directly off the CD anyhow.  I copy programs to the hard
disk.

I have a friend who has the same CD-ROM drive but uses a "green" 486DX2-66
VESA local bus which conflicts with timings.  I have no such problems with an
Orchid 486DX-50 VESA local bus.

... On the 8th day the Corp of Engineers Changed Everything!