@marcusalwayswins, some good news! I am re-recommending the 8GB M1 Mac Mini, even for Affinity Photo.
I installed AP on my i3-6100 SkyLake box with an nVidia GTX 950, all drivers and Windows 10 fully updated. With 16GB of RAM AP exhibited noticeable lag compared to the 8GB M1 Mini. When importing photos the WinTel box consumes ~1GB of RAM for each RAW imports -- so less memory use than the 2GB per RAW import on the M1 Mini. However, performance on the 3.7 Ghz SkyLake with 16GB was laggy and the exposure slider took 2 seconds to reflect changes. This was connected to 4K monitor.
Next up, I installed AP on my 2015 MacBook Pro (2.7 Ghz Intel i5, 8GB RAM, macOS Monterey) and connected it to the 4K monitor. I learned about the Developer Persona Assistant and setting the RAW Engine to Apple Core Image RAW instead of the default Serif Labs. This cut memory consumption in half, matching Affinity Photo on Win10. My old trusty MacBook Pro did admirably and was a more pleasant experience to edit in AP than the WinTel box. The exposure slider still took a second to update changes but it was noticeably quicker than my 16GB Intel PC.
Lastly, I switched to Apple Core Image RAW on the 8GB M1 Mini and memory consumption expectedly went down by almost half and I can now comfortably import a dozen RAW files and edit them in real-time without any lag. If you can stretch the budget to a 16GB M1 then I'm sure it will serve you well for many years. For myself, I'm going to purchase Affinity Photo and keep my 8GB M1 Mini.
Affinity Photo RAW Engine set to default "Serif Labs", (after importing 3 Sony RAW files):
View attachment 2109063
Affinity Photo RAW Engine set to "Apple (Core Image RAW)", (after importing 3 Sony RAW files):
View attachment 2109068