Not sure about the base M2 Mac Mini, but my M2 Pro Mac Mini is sufficiently fast. It can compile Firefox in under 11 minutes...compared to over 60 minutes on a 2016 MBP with Maxed out Quad-Core i7. Maybe comparing it to a dinosaur isn't saying much but I always thought that my MBP was fast.
Caveats:
1) Might want to double check, but it sounds like preconfigured models will have 1 NAND chip for SSD, giving half the I/O speed. Same for M2 MBA and M2 MBP apparently. I may have seen a YouTuber say even the base M2 Pro has 1 NAND chip. I got the default +1 option for SSD to avoid. AFAIK, the M1s didn't have this?
2) Apple needs to sort out their network issues that many people are seeing with the M2 Pro Mac Mini. Getting 60-70% packet loss out of the box is unacceptable. There's a usable workaround that is quite easy, but that feeling when your new computer doesn't work...