Joy Division - Unknown Pleasures
Not a "good" or "nice" sounding record, but odd, bleak and desolate, just like the music. Very cool.
But you bring up a great point because first and foremost, great engineering and sound should support the artistic statement and emotion. If it doesn't do this, then it really doesn't matter how great the microphone was or how "hi-fi" or "lo-fi" the sound is or how great the editing was or any of it. Every single creative and sonic decision should support the artistic and emotional statement.