Sorry, but I think many of you are missing the point.
The ship is supposed to be ugly. It's a dark nasty future with a old miserable and hunched Riker with a nasty hunched Enterprise in a dark war torn future where an peaceful exploration ship had a lot of guns welded to it so the Federation could survive. This is the future to be avoided. It's not supposed to be nice.
All that out of the way, I like it!