I would always choose an SSD if I had the space and the free SATA port.
I think it might help to understand the vast orders of magnitude difference in reliability between a USB flash drive, a SATA Dom, and a SATA SSD. It's also pretty easy to default our thinking that failures are random events. However, with mirrors, both drives, whatever they are, are subjected to approximately the same wear. This usually means that their failure is highly correlated, not independent. Therefore, having two USB drives doesn't really give you twice the protection. In fact, it may only be slightly better than one USB drive.
When you look at modern SSDs, thanks to their large capacity, high cell longevity, and advanced wearleveling techniques, it becomes highly improbably that you can "wear out" an SSD with the FreeNAS workload in your lifetime. There is always the possibility of an infant failure creating problems, but those are pretty unlikely as well.
In an enterprise environment, where uptime is key, I would always recommend dual SSDs to avoid any downtime issues related to those rare (but possible) infant mortality issues. However, for any typical home user, downtime isn't really a huge problem, and as long as you are backing up your config, you'll be back on your feet as soon as you get another drive. And an SSD will mean, for most, a lifetime of hassle free use, while USB flash drives will inevitably need to be replaced after a couple years, and a SATA Dom within a decade.