i have a lsi logic,i dont use the card directly with the mpc,but i did use the scsi drive from that computer.(68 pin 28 gig)inside the mpc. it worked fine but this weekend i switched to an ide 2.5" 20 gig. because the scsi was a full size drive & generated a lot of heat.
Adaptec AHA2940U works with the S2000 type samplers. I don't know if you can do anything at all with an MPC though, cause it doesn't have something like MESA.