Is detailing a car worth it?

Yes if you are going to keep it long-term. Cleaning before selling makes no difference at auction though.