As you said, RAID gives you a single unified storage pool from independent drives.

It also gives you some fail over if using RAID 6 with dual drive redundancy and hot fail over (which any modern RAID system has).

You can then divvy up the storage however you want. Single big drive with folders and file-system permissions, or split the pool into multiple logical drives, etc.

The world is your oyster.