Molecular Gas in Infrared-Excess, Optically Selected and the Quasars Connection with Infrared-Luminous Galaxies