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.