I don't know about TrueNAS, but with Proxmox the two random 10$ SATA-cards I tried only gave me issues. With first one OS wouldn't boot, second seemed to work fine, but connected drives disappeared as soon as I wrote to them.

Used server-grade LSI cards seem to be the way to go. Too bad they're power hungry based on what I've read.