Adaptec gear is ridiculously overpriced (not this time though 🙂). That Diamond card uses an LSI chip (formerly Symbios formerly NCR), who were and still are the #1 driving force behind SCSI. It's just that you don't find their own adapters on the shelves so much.
The 2940UW has had quite a few BIOS and driver issues, alleviated by some of them not being flash upgradable. If you're buying old stock there, you should pick the Diamond. Unlike Adaptec, LSI's SCSI devices are all fully software compatible, from the original NCR53C810 from 1992 or so up to the current LSI53C1010 dual channel U160 thing. You won't find a more mature BIOS and driver set anywhere else.
regards, Peter