Happy to say that the LSI card worked like a charm and I now see all drives present and accounted for - again, thank you all for pointing me in the right direction! I'll be marking this as solved now