Generally, Firewire cards based on the TI (Texas Instruments) chipset are regarded as the most compatible. On the rare occasion that users have reported issues, they were usually on cards (or motherboards) using Firewire chips from VIA and NEC.
ADS has a pretty good reputation, so either of the two 1394 cards you listed would probably work just fine. To my knowledge, there are no cameras which use Firewire-800. If you're talking about storage, then eSATA is probably preferred over Firewire-800 unless you are looking at doing an external RAID array of some sort.
"The sustained data rate of Firewire 400 is already faster than any SATA or PATA hard-drive"
Not entirely true, Firewire-400 has a max throughput of around 50 meg/sec, but the fastest transfer rate I have seen with a single drive via a Firewire-400 interface is about 35 meg/sec.
Using eSATA with a single drive is as fast as the drive itself. I have seen sustained rates as high as 80 meg/sec using Seagate 7200.10 SATA drives, over twice that of Firewire-400. Across the entire drive, the average transfer rate was 64.6 meg/sec.