The Enterprise-D had it right, almost taking cues straight out of aircraft passenger cabin design. Keep the environment bright and cheery (although they missed the 'avoid hard angles' part.)
Not to mention glass coffee tables...

You do have a point there. But I could argue that there is a considerable design difference between the Galaxy class Enterprise-D and the Intrepid class. The Galaxy is a 'luxury liner' designed to hold families as well as the crew, which justifies the softer color tones. The Intrepid is smaller and less oriented towards deep-space exploration missions.It strikes me that relentlessly hammering into the heads of a crew that they are living in a tin can of air, day after day, for years, can only aggravate the psychological issues inherent in such situations.