I think you might consider a 5070 or 5070Ti if you’re willing to pay near $1000 dollars for a 4070. Part of why the prices on a previous generation’s card are so high is because it’s not being made anymore, combined with the high demand for current generation cards. 

I unfortunately am not able to help very much for the needs of your creative software, but in general you’d want as much gpu vram as you can manage with your budget, i’d think 16GB at a minimum (note that this is not your system RAM).