The following review paper can help to navigate through the zoo of single-reference excited states methods
Single-Reference ab Initio Methods for the Calculation of Excited States of Large Molecules
Andreas Dreuw and Martin Head-Gordon
Chemical Reviews 2005 105 (11), 4009-4037
DOI: 10.1021/cr0505627