I’m looking for a PC for gaming and photo editing

Hi, Several years ago I got a professionally refurbished workstation for my photography studies and was able to choose a graphics card for gaming (because I love to gamble).
While the device still has great performance for its age, it is unmatched in power consumption and almost as loud as a vacuum cleaner.
Since my graphic card has been on the rise for years and electricity has become more expensive, now is the time (with vacation bonus) to replace the device and take care of power consumption as well as performance.
The biggest question mark is the graphics card. I hope you’ll give me some tips here that take my main interests in gaming – photography and saving electricity (compared to now) into account and put them in a good rapport.

1. Do you want to play on PC?
yes. Something like Elden Ring and the company in HD and multiplayer like Overwatch (2)

2. Would you like to use your computer to edit photos/music/videos or CAD? As a hobby or are you a professional? What software will you use?
I’m a full time photographer, but I still do it privately and mainly use the Adobe suite. Dealing with many large RAW files. A graphics card is also likely to be suitable for video editing software if you wish to further your education in this field.

3. Do you have special requirements or wishes (overclocking, a particularly quiet PC, RGB lighting, …)?
energy saving
With pleasure again NVIDA (can use screen performance)
Preferably an AMD CPU
Good performance (comparable or better)
Memory card slot (CompactFlash) directly on the cover Is there such a thing?

4. How many screens do you want to use? Number, Model, Resolution, Refresh Rate (Hertz)? Do you support FreeSync (AMD) or G-Sync (Nvidia)? (Please with a link to the manufacturer or compare prices!)
I’m currently using an Iiyama G-MASTER GB2730HSU LED monitor (1920 x 1080 pixels, Full HD, 1ms response time, 75Hz), but would prefer working with two screens again in the long run.
(I got the monitor to play with. I don’t professionally rely on a computer, because I have a MAC at work and can use a MAC in my studies and there are good monitors and calibrates there. However, I use my full format camera and want to be able to work on that much Large data in a comfortable way on my computer without a lot of calculations.
As far as the rest of the parameters are concerned, I know roughly where to go. Only with graphics cards I don’t know where to start.)

5. Do you still have an old computer, parts of which can be reused? (Please with links to specifications from the manufacturer or compare prices!)
Existing PC will be sold (without Monator):
Intel Xeon X5670
HP Z800 workstation
24 GB RAM
NIVIDIA Geforce GTX 970

6. How much money do you want to spend?
1100-1200 maybe more if the sale of the old computer still gives something

7. When do you want to buy the computer? ASAP or can you wait a few weeks/months?
July/August 2022

8. Do you want to assemble the computer yourself or assemble it (by the store or by volunteers)?
Has it been assembled (by my brother)