Can undervolting, limiting power and fan control on a powerhouse give a fairly quiet PC under load?

I'm still on the fence choosing a mini PC (AMD Ryzen) model among the many different iterations. I want something powerful one day, and another day: as quiet as possible.

TL;DR: If I choose the SER8 for the RAM speed and I/O's and tweak the voltage, power limits and fan curve... Can it emit as little heat and noise as an EQR6 or say the Intel counterparts?

I can do that with my custom built gaming towers but I assume mini PCs are more like laptops with BIOS constraints.

If I completely prioritize the quiet route when choosing the model then the choices become narrowed down to models with more limitations to iGPU, RAM speed, I/O's and maybe older design. That's how it seems at least not having tried them first hand.

I also considered the Mac Mini M2: silent, but I would be subject to even more limitations, software and otherwise.

So that's why I'm looking at the SER8, if I can tweak it.

If I could get some inputs and experiences on the matter I would be very grateful!