The most important spec for fans is the max AIR FLOW they can generate at max speed. When operating, the mobo's default fan control systems will slow down th4 fan according to actual temperatures measured by a couple of sensors, so the fans produce less air flow, just right to keep the temps under control, even as you change workload and heat generation. So having a fan with high max air flow means it will be slowed down a lot from that, so the fan normally generates less than the MAX noise its specs say.
Ideally, you want fans with high max air flow and lower max noise. A fan with higher air flow max but the SAME max noise rating will actually create less noise in normal reduced-speed operation.
NOTE in choosing fans: ones to be used on heat exchangers (air coolers) or on rads (AIO liquid cooling systems) must deal with higher resistance to air flow in those small finned spaces, so they need to have a higher rating (than case vent fans) for the max PRESSURE they can blow against.
All these details of fan performance specs differ according to the way the fan is designed, so all makers' fans will be different. You do ned to read and compare their individual specs.