Efficient correlated electronic structure theory and quantum dynamics for photoactive systems from small molecules to biological macromolecules