Ab initio Quantum Chemistry Methods for Modeling Molecular Excited States Beyond Configuration Interaction Singles