There is no such thing as a "normal SATA PCIe HBA". You're talking about a SATA controller. Call it that.
Please read the following and make sure you are NOT using a device that integrates a SATA port multiplier.
This resource was originally created by user: jgreco on the TrueNAS Community Forums Archive. Please DM this account or comment in this thread to claim it. In the last year or two, we’ve had a resurgence of users asking about SATA Port Multipliers and cheap SATA controllers. Please, do NOT use...
www.truenas.com
Note that many "5 port" devices integrate a SATA port multiplier and will bring you misery.
AsMedia 106x based controllers that do NOT use a SATA PM have generally been found to work well if they are genuine. There are lots of knockoffs though. Buyer beware.
JMicron JMB58x controllers may work on FreeBSD but have had NCQ disabled due to various issues, and that will make them perform poorly. You probably don't want a poorly performing SATA controller for ZFS. Linux driver support has been a little dodgy as well, so you should probably find yourself an AsMedia instead.
Other JMicron controllers have various issues that make them undesirable. Remember that many of these are mostly "made for Windows" in some Shenzhen back alley operation pumping out cheap knockoff silicon.