Text this: Comprehensive DFT investigation of Cd-based spinel chalcogenides for spintronic and solar cells devices