Faint Optical Line Emission from the Diffuse Interstellar Medium - Observations and Implications