Production that correctly highlights or enhances aspects of songwriting/musicality that are effective in conveying whatever message a band wants to convey is the fucking shit. One great recent album that does this well is Lost Soul - Immerse In Infinity. A few other favorites include Textures - Drawings Circles (sounds exactly as open, expansive and progressive as it needs to without selling itself short like the band they obviously love [Cynic, duh], nor going too pompous and pretentious [also like said band they love yet are better than] and Soilwork - Natural Born Chaos which was done by Devin Townsend and sounds amazing.
Bad production is just bad. So, on the other side of the coin, Soilwork's Sworn to a Great Divide has god awful production that makes no fucking logical sense, it's a damn good thing their songwriting on that album is generally pretty good, and a bit out of the ordinary for them. Other bad production jobs, imo, include Defeated Sanity - Psalms of the Moribund which is absolutely fucking abysmal and muddy for no reason whatsoever, and Morbid Angel's Blessed Are The Sick, which, in addition to having some really boring/filler/non-stimulating songs, has some flat fucking production. I much prefer Altars for its right-for-the-jugular, straight-up, catchy yet compositionally superior style (and the production doesn't detract from the riffs).
Oh, and the aforementioned Cynic may have musical chops but, other than that early demo (which I give a pass cuz it's a demo), they've never managed to combine solid songwriting with well-done/fitting production, which is fucking retarded considering how well-liked they are. Focus just sucks intensely all around, but I remember hearing "Evolutionary Sleeper" live before Traced in Air came out, and it sounds AWESOME live in that one video...then, way to go guys, you sterilized the shit out of it and now it sounds god awful.
P.S. Andy Sneap is also a shit producer and anyone who likes him as such can fuck off and die.