Worst thing MS added to their operating systems - always go hardware raid. For cards look at LSI.
One of our clients lost a server recently, as it was configured with windows storage by the previous it company. We did managed to recovery the server by restoring a backup
Windows Storage Spaces is not good… i think even the motherboard BIOS raid is better then Windows storage spaces and almost no one recommends using the desktop motherboard raid… But it is one step better then windows solution.
as you plan on using this in a business environment… consider DVR/NVR solution instead of running it on windows 11 pro… win11home+pro is not stable enough to be reliable… you need to really tweak win home/pro hard to get it that stable if you should run it 24/7… Consider learning Linux for a Linux solution of you want to run it on a regular PC
and if you still want to go down the win11 road… even a cheaper raid I/O card is 100times better then windows storage spaces.
Dont forget to block windows automatic updates so the system dont reboot in a situation when you dont want it to reboot… I dont use win11 but i have a feeling win11 updates are forced as win10 is on home/pro editions