First rule of RAID -- have a complete backup since it is only fault tolerant storage (except RAID 0 which is no fault and rarely useful since SSDs became available).
I usually use enterprise drives (HGST He8 mainly) for RAID 5 arrays, the writes on RAID 6 are just to slow for most things I do. That said, I did use HGST 3TB 7200rpm consumer drives in the past for years without incident in RAID 5 (8 drives) with a hot spare and good backup. Never had a URE with hundreds of drives over many years but they can happen, hence the essential need for backup.
IMO the real issue with RAID is the quality of the controller -- no motherboard controller should be considered at all reliable, any bios hiccup and poof all gone. That is a very common storage forum problem.
Adaptec/LSI/Areca controllers are the way to go. If you can't afford that, you really don't need hardware RAID, simply use Windows Storage Spaces.
If you have the time and inclination, FreeNAS using RAID-Z is also a very viable alternative but it does require a dedicated box to run.