I was able to set it up again without reinstalling after switching from ACHI to RAID. All I had to do was uninstall Intel Rapid Storage drivers, select reboot from safe mode, change from ACHI to RAID before Windows loads, load in safe mode, select to boot regularly, and my next boot I booted with RAID enabled and no issues what so ever. Reinstalled ITRS and am currently rebuilding my original arrays.
I still have the problem though where I will have difficulty changing this over when I get a new motherboard. Considering all the good news I have seen around AMD it is likely one of those might be my next boards and I am willing to bet the RAID drivers aren't even close. At this point I would manually have to restart the RAID arrays and physically copy the hard drives on a back up drive to rebuild them. That is a lot of work I had hoped to avoid with getting an actual hardware RAID card.
So my question ultimately still stands... how do I make the 9240-8i hardware card work or can someone provide a sufficient card that is simple to install, can reliably do RAID 0, 1, and 10, and is easy to manage disks in Windows?