The biggest consideration is to get a card that pfSense supports (which means something that FreeBSD supports). Luckily this includes a lot of options now. Honestly something like the Mellanox Connect X3 or X4 card will likely work fine. The X3 card can be found very for very little money on EBay for example.