I may be the exception that proves the rule, but I installed and have been running Zorin 16 since April on a Dell Optiplex 7060 single-drive PNY CS900 SSD with RAID enabled. No problems that I can see.
I suspect that the switch from RAID to AHCI is recommended, but is mandatory if and only if the installer does not recognize the install-to drive.
I've had the same experience with SolusOS. I first installed it on the 7060 with RAID enabled, and then moved the disk to a RAID-enabled 7070 when I did a hardware refresh two years ago. Four years, two computers, and no issues.
I know a lot of people have had serious issues with Linux and RAID, so it might be that Dell implements RAID in a way that doesn't cause Linux issues. Dell is a major supporter of Linux, offering OEM Ubuntu on much of its line and supporting subsequent Ubuntu installs on a large number of OEM-Windows computers, so that's a possibility, I guess.