Approaching Accurate Description of Molecular Spectroscopies with Multi-reference Electronic Structure Methods