For me, this would depend on what the plan is for it.
If it was to be my own residential property then I'd probably want something that needed as little work as possible but I'd still be able to put my own mark on it to personalise it for us.
If I was buying as an investment property then depending on my funds, I'd like to buy something that needs some work and therefore able to buy it for a low price, give it a full makeover and then sell it on for a reasonable profit and then invest the profit in another project.
Or, if I was looking for a new BTL property then I'd look for something that needs very little work, maybe a bit of brightening up here and there, but mainly something that will will have a minimal turnaround from my purchase to going on the rental market.