You definitely want a card that's PCI-E. That Delock one would work but it's still very much a basic SATA controller so I can't vouch for the reliability. LSI definitely do some decent looking PCI-E HBAs for not too much money on the used market. Many cards will offer some type of RAID functionaliy but look at the specs, as long as it has a "JBOD" or "HBA" mode, you can use it to pass the drives directly through to your OS.
If your card only supports RAID, you can technically just create a bunch of RAID 0 arrays where each array contains a single disk to pass each drive through to the OS and then RAID them in software. This would work although it's not ideal as the abstraction created by the RAID controller can make things like monitoring drive health a bit more difficult than it would be with a proper HBA.
You'll probably find that decent, high end cards will use a miniSAS connector rather than individual SATA connectors as shown below. This is fine, you can fairly easily find an appropriate cable to break this out into individual SATA connectors.
![](http://i666.photobucket.com/albums/vv22/per1-q1222/RAID/sas_SFF8087_closeup2.jpg)