Accurate band structure determination and derived properties for strongly correlated materials with optoelectronic and photocatalytic applications based on advanced wavefunction and tensor network methods