Brand new vs fairly used: which gives better value?

Share when buying used makes sense and when buying new is worth the extra cost.