The CS MK2 will easily give 8 MB/s in most setups and so will the FastATA 4000 with selected HDD's/CF cards. Zorro 2 bandwidth is limited as noted in the thread, but as also noted (by me) the CS MK2 SCSI resides on the accelerator bus, not the Zorro and is limited by SCSI-2.
Although I have done a bunch of benchmarks and reported the OS4 vs OS3.9 numbers in the hyperion classic forum, I own a Buddha Phoenix (new Amigakit release), a FastATA 4000 latest version, CS MK2, CS MK3, and CSPPC; however my real mantra is, "If is seems fast, then it is."
The accelerator really helps makes is seem fast and anything above SCSI-1 and the Amiga built-in IDE does as well, so pick something that fits your budget (I always spend days making decision like that) and go for it; in the meantime, overclocking a CS MK2 to 66MHz is fine since you don't have the SCSI module to worry with (or higher if you can find fast RAM).
OFF TOPIC and as an aside: on both my A4000T and X1000 running OS4.1, you can use a SIL3112/4 PCI card, that's not fast, but gives you easy access to SATA drives (on the X1000 I use 3 SSD's on the MB SATA, but a 1 TB backup on the SIL3114). I have a 1 TB backup drive on the SIL3114 in my A4000T and a SATA DVD-R/W.
Off topic: I consider the CS MK2 and SCSI module a "pair" and if I can buy only one, I wait to complete the pair with the other. Cable routing is hell, but they are nice!