With that little amount of hardware an 80MB/s channel would be fine..
Adaptec 2940U2W.
Keep in mind you can have 15 devices on a SCSI card, so U160 was designed so you could have 4 or 5 big meaty hard drives going at once, a PC does
NOT need Ultra160. That hard drive going flat out full bore transfer with no seeks will not be able to hit half of 160Mb/s, probably more like 50. 40x CDRom is less than 5MB/s
.
Having said that....I'd get an Adaptec 29160N or 19160 if you only use windows (same board difference drives/firmware, the 19 is Windows only the 29N is Windows and Unixes and Linux and even BeOS I think).
Even the 2940U2W is still fairly pricey and if you are going SCSI i'm of the impression you don't really give a damn about $50, so I'd probably just grab the best, and IMO that's Adaptec 29160N.
[Edit]
Ok ok, the 29160N is not quite "the best"
There is the 29160, which is similar, I think it has a 2nd channel for smaller SCSI devices, like Pritners, Scanners, CDRWs, Zips, but you won't have 15 hard drives
and is also PCI64 capable but you probably don't need that, and of course the mammoth, the 39160 which is dual channel ultra160, but you really don't need that
[/Edit]
The Tekram DC-390U3W is also very nice, similar to the 29160N but alot cheaper, but it's not adaptec.