The $599 model is for a basic user who barely does anything more than browse the web and send emails (which is to say, a lot of people). It's not a pro machine.
I feel this website is a strange bubble. I use an underpowered laptop from 2013 for all my daily tasks including light photo, video and audio manipulation and I have no problems. Why does it always have to be about videogames, heavy creative work, multiple VMs or compiling gigantic codebases?
One thing to keep in mind is the demand of the specific OS/applications you are running. For example, 1GB of RAM is plenty for Windows XP, but 4GB for Windows 10/11 is abysmal. This is more or less why Linux is such a popular choice for repurposing old computers.
I feel like such a "basic user" would be better-served with an iPad or even a MacBook Air, unless they happen to have a monitor, mouse, keyboard, speakers and webcam from, say, their old PC. Historically Apple has marketed the mini as a "gateway drug" to Macs. Cheap, and people can just reuse the peripherals they already have. Even now I wouldn't recommend an entry-level mini to that "email and web" crowd.
I know from personal experience that if you are using the mini for anything of substance, and only have 8GB of RAM, you are using your SSD as "RAM" more than you probably realize.