I'm running a selection of 15k cheetahs off a Dell Perc 4e d/c and it is, as described by RPStewart, an interesting learning experience. I'm maxed out at 160mb/s ish as are most of us running this combo, so your selection of u160 isn't the end of the world, but you really do need to look at a Pci-e solution if you want anything more than a bit of fun.
The low access time is great, and I do get into BF2 1st (every time

) but TBH the difference these days is tiny (couple of seconds) as there is a lot more to level loading times than pure drive speed/access time (unfortunately). We had a great debate about this a little while back - will try to dig out the thread - and the bottom line was that even running off a RAMDrive, you gained only a small advantage, so it really isn't worth the effort (or money).
You're better off getting a couple of the new Samsung F1s and raiding them next month if you want fast transfer speeds. (Especially on the new intel matrix controllers which seem awesome!)
That said - Scsi is great fun, and pretty cool - especially the new Sas stuff, but it is hugely expensive at the bleeding edge. If you can track down a cheap controller card (pci-e) the Seagate Cheetahs (15k3) 18Gb drives can be had cheaply and are pretty quick. Do watch out for the model numbers as the 80 pin ones are a nuisance - the adapters are only a couple of quid, but they're not as reliable as the 68 pin ones if you don't invest in a proper backplane.