I think it is a great artistic tool, as long as you live with its foibles. Live View can be hard to turn on, but a function button can be assigned to do that.
My biggest complaint is the mushy multi selector knob on the back. Mine was hit or miss, so I bought a new ‘old stock’ one on eBay. It was very easy to fit, along with a new set of the four vertical rubber buttons. In fact all of the back buttons, and the lcd screen are very easy to replace, so if you do opt to but a D700, and it happens to have wear on the back, you can be pretty sure you can fit new thingamijigs.