Run Adobe CC = macOS or Windows, NOT iOS so no iPad will do the job unless all you need is the lightweight Lr companion app. If you need the full power of Ps, Lr, Ai, and/or Id then no iPad will serve.
$1000 budget + macOS = basic 13" MacBook Air, period (unless you find an older model used).
Truthfully, you'll find better performing Windows devices for less money. The 13" MacBook Air is a dual-core i5 machine in a standard notebook config. With a $1000 budget you can get a 13" Dell 2-in-1 an i7 and matching RAM. The Dell has a touch screen will fold over to act like a tablet. For $50 over you budget you can get a similar Dell that's 15". There are many many other options.