That is the exact market for base mac mini. My father in law has a base M2 mac mini I bought him and he is maybe using 80gb of hard drive space because all he does with it is read emails, buy stuff from Amazon, and watch conspiracy youtube videos. Has 8GB of memory and when I ask him if its fast enough he raves about it.256GB is getting too small for anything beyond “personal productivity“ - and I’m not sure that’s the market for a Mac Mini (base MacBook Air maybe).
The base mini is the entry level desktop mac for every day use and its priced as such.
My wife has the base M1 and has no problem either, she uses it to pay bills and read news before she goes to bed.
The problem is the actual demographic for a base mac mini isn't going to a Mac forum to talk about macs, and the 10 people here who are in that demographic are the ones who are like "Still using my 2018 i3 and it works great!"