The Art of Choosing the Right Quantum Chemical Excited‐State Method for Large Molecular Systems