Is a 10 Year Old Camera Good Enough?

Learning there is no perfect camera and only the best tool for the job - how can we pick the perfect camera for us?