hardware raid contains all the hardware required to present your system with a single drive like any other, software raid is all performed in software, essentially draining cpu and memory to achieve redundancy and/or higher throughput, if the RAID is important to you and you can spare the performance hit in other metrics it can be worth it.
RAID cards are essentially like a small embedded system with their own cpu and ram, hence why they are so expensive.