Can I see the RAID group name for my SQL Server Database files? Is it possible to see the RAID group name that my database (and log) files are sitting on, in one of the DMVs (or some other system table) ?
SQL Server doesn't have any access to anything that low level.  Typically Windows can't even see the RAID group information given that each hardware vendor stores that differently and typically exposing that information to the OS doesn't have any benefit.  You'll need to work with your hardware team to make the drive labels match, but even then that isn't exposed within SQL Server.  You would need to use PowerShell or WMI to pull that information from the OS.