Your biggest issue will be with your adderall.
That’s a non-starter as far as the FAA is concerned. It’s likely going to be an uphill battle as far as getting that removed from your records.
I’d contact AOPA and talk to their medical specialists.
As far as the rest... again. An uphill battle probably. But not insurmountable.
Will Delta hire you? Probably not.
But there are plenty of others that I think will.
Again, AOPA. Reach out to their legal team and get advice. You said the drug charge was expunged, so that’s good. How good is something you’ll need a lawyer to determine.
But first and foremost, the ADD and the adderall. That’s your biggest hurdle.
Good luck.