Probably not a good time to be transitioning to Mac to be honest, if you don’t want the 24” iMac.
All new ARM based Macs use the M1 Soc like the new iMac so if you think think the machine spec is ridiculous then not going to find a higher spec ARM based system at the moment.
Intel based Mac probably not worth investing in right now unless have requirement to be able to add an eGPU, run Windows. Also forget Nvidia GPU is AMD all the way on Mac these days.
on some older OS youncan get Nvidia GPU to to work but if going to MacOS for reliabiliy do you want to be thinking with system to make and keep it workin.
Mac Pro 5,1 can be made to work but basically is done by enthsiasts who determined to keep ther 5,1 going. Doesn’t sound suitable to you for me If wanting the reliability.
On a Mac I wouldn’t get hung up on the spec.
Whilst some people talk about the lack of upgrade ability on the Mac then there are also people that will basically change there Mac every new model or even 2 years, as they hold the resale well, and they don’t find the cost prohibitive. 2 years so still has AppleCare running.
Other people are content to use a Mac a few years older and buy second hand, use for a few years and then get a later second hand unit.
this may be a better option then a new Intel Mac for you.
Apple does have a good return policy so can buy an ARM based Mac and try out and if find that no good for you return within the window. However from your stated usage I reckon a 24 iMac would suit what you need, or even the Mini, just make sure go for the 16gb ram versions.
ARM Soc currently offered with max 16gb so no more at the moment.