Computational Studies Of Electronic Excited States, Or: How I Learned To Stop Worrying And Love Multireference Methods