Some answers. So two of the sata port will be used with optical drive dvd/rw and blue-ray/r so performance shouldn't be too much of an issue; the other 7 will be used for 4+2 software raid and boot disk; so the 4 ports on the asmedia would be 2 optical which are only used once in a blue month; 1 free and 1 boot disk.
If you only use it with ODDs and a boot disk, I don't see any problems. Which leads to:
The pci slot is used with a 15 year old tv tuner. I've looked at pcie options and linux doesnt' seem to suppor them very well (at least the analog input; I have the tuner hooked up tot he analog output from comcast converter box - this is sd). It looks liek the 950q (usb device) is suppose to work with linux so I might try one of those and if it works I could drop the pci slot requirement. I do have a requirement for display-port and since this post I've come to realize that the gigabyte board lacks display port but I could go witth the newer z97 extreme6 (unless there is something better).
I must admit I haven't kept current on TV tuner cards since our national TV service started streaming everything over the internet (don't view that much traditional TV). So I'm really not in a position to advise on that part...
If you have a DisplayPort requirement, it narrows down mainboard choices a lot unfortunately. If you can replace your tuner card, I think the only worthwhile Z97-board is the Z97 Extreme6. Its simply the one with fewest compromises and you get a nice bootable M.2 x4 slot separate from the southbridge for possible future use.
(biggest compromise is only being able to run the PCIe 3.0 x16 slot at x8 when the M.2 x4 slot is occupied, but the performance penalty is really minimal)
The sata controller you linked is $100.
That was just the manufacturers page with list price. If you shop around, its a bit cheaper:
http://www.newegg.com/Product/Produc...-365-_-Product
Controller cards are expensive unfortunately. There is little we can do about that. But that $71 does give you a 7 port card that works with every board you can think of, and you can easily transfer your setup to a new machine. Without worrying if the new board has the required number of SATA ports.
I'm not going to recommend either way, both solutions have their own strengths and weaknesses.