Is the Quad SATA Hat compatible with a Raspberry Pi 5 board? Also, would the outer case in the kit be compatible with 90 degree angle sata adapters?

All you need to do to enable the Quad HAT in Raspberry Pi OS is to follow the instructions here.

To enable hardware RAID follow the instructions here.