I absolutely recommend ZFS. I've been burned by MD (the other software RAID) because it doesn't scan the array for bad data, so bit rot and silent errors can go undetected until a process wants to read it. ZFS periodically scans the array and fixes corrupted data if possible.
ZFS can use more CPU resources compared to MD, but the difference in performance is insignificant compared to the read bandwidth of mechanical hard drives. Memory usage is comparatively high because it uses the RAM as cache, but you can set a limit. My current 8TB RAIDZ1 array uses only 8GB of RAM and it could still be lower.
I recommend using some dedicated OS to manage ZFS pools, like TrueNAS Scale or Proxmox.
https://pve.proxmox.com/wiki/ZFS_on_Linux
it’s not default in mainline linux
It's purely an issue of licenses. ZFS is a mature solution, and being out-of-tree does not reflect a qualitative issue. It's available as a separate package on most distributions.