There are no NUCs that have two regular SATA ports. In fact, there has never been a NUC that provided two regular SATA ports.
The taller "H" NUC models have a bay for a single 2.5" SATA HDD/SSD/SSHD. The 8th gen BE NUCs (the NUC8i3BEH, NUC8i5BEH and NUC8i7BEH) also have a M.2 slot that has support for inserting either a M.2 NVMe SSD or a M.2 SATA SSD. There are companies that make adapters than expose the SATA lane included in the M.2 connector using a regular SATA connector. Here is a link to an example: https://www.amazon.com/gp/product/B07G2YXLFP. You can use an adapter like this to expose this SATA lane and thus have two (somewhat) regular SATA ports. Remember, however, that there is only room in the NUC's drive bay for a single SATA drive (and, in fact, it has to be one that is less than 10mm in height). This means that you would been to mount whatever you connected to this adapter outside of the NUC chassis.
You can use RAID with either two M.2 NVMe SSDs or with two SATA SSDs, HDDs or SSHDs...
Note the following:
Hope this helps,
[Edit: I tried a couple of times to fix the formatting of this message but the site has a bug!]