I've got absolutely no experience with AOS4.1 and/or Cyberstorm SCSI but: AOS4 runs a driver of its own that needs to initialize - this appears to be the problem.
Make sure your terminators and cabling are AOK. U(W) SCSI is the pickiest of all SCSI flavors: short cabling and active termination are mandatory - old active terminators have been seen to quit with Ultra speed; anything LVD/SE will be fine. If the SCSI/IDE adaptors include terminators those are probably fine, too. Do these bridges support Ultra speed? Have you tried lowering the CS SCSI speed to Fast?
PS: have you waited long enough for the driver to initialize? I've read somewhere that this may take a while if high (low?) IDs are used or the last HDD isn't tagged as last (so the full range of IDs needs to be scanned).