I am a high end beauty,portait, fashion, editorial retoucher. Please help me

Are those the system requirements for the software you use? If so, this is an issue:

- Processor: 3.2GHz 8-core Intel Xeon W processor,

if that is the only processor the software can use. The last Mac that used Xeon processors, the Mac Pro (not iMac Pro) was discontinued a year ago. The iMac Pro with Xeon processor was discontinued over three years ago.

If shopping for a new computer, you need to contact the software developer to see if they support Apple Silicon. If they do not, you'll need to shop for a Windows computer.

I checked the Apple refurb site and none of the refurbed Mac Pro models currently available have Xeon processors.

A quick search of MacTracker for Macs that have both Xeon W processors and Thunderbolt 3 ports turned up the iMac Pro (2017) and Mac Pro minitower (2019).

The references to a 27" 5K screen and a weight of 9.7 kg (the iMac Pro weighs 21.5 pounds, or 9.77 kg) appear to confirm that the reference is to a particular variant of the iMac Pro (2017) all-in-one. A Mac Pro (2019) mini-tower weighs far more (about 80% more) than a iMac Pro – and has no built-in screen.

Each of these two machines had several GPU options. A Vega 56 GPU with 8 GB of VRAM was the base option for the 27" iMac Pro.

If you are thinking of buying a used iMac Pro (2017) with those specifications, that was a very powerful, high-end Intel Mac. Aside from the SSD being a little on the small side (not a big issue – you can add external ones), those are pretty good specifications. The screen – like all 27" 5K Retina iMac screens – is nice, and you cannot beat its resolution, though a high-end ($$$$) Eizo might have more color accuracy related features. The expansion ports are reasonably up-to-date, too.

That Mac can run the current version of macOS (Sonoma) and will be able to run Sequoia when Apple releases it a few months from now. Because it has an Intel processor, you could buy Parallels Desktop and a copy of Windows and run a lot of Windows software inside a virtual machine (if need be).

On the other hand, Apple has completely transitioned their product line away from Intel chips to Apple Silicon ones. Most Macs are now up to second-generation (M2-family) or third-generation (M3-family) Apple Silicon chips - and the iPad Pro recently got a fourth-generation (M4-family) chip in advance of any Mac getting one.

This means that the "writing is on the wall" as far as Intel Macs are concerned. I would not count on the iMac Pro being compatible with the (as-yet-unnamed) version of macOS that will eventually follow Sequoia.