Grain of salt disclaimer: Numbers here are for reference, ye makes yer choices and ye picks yer poisons...
Selecting one of the newer 846+24 SAS 846s (rev k) off the Supermicro website (since they've got more cooling than prior versions) and the cross-referencing the fans show the following stock fan stats ...
Chassis:
SC846XE2C-R1K23B | 4U | Chassis | Products | Super Micro Computer, Inc.
846, 24 SAS + SAS3 backplane, dual 1400 Titanium PWS.
Midplane: FAN-0115L4
92x92x38, 7500 RPM, 155.0 CFM, 1.31 inH2O, 60 dBA
Rear: FAN-0125L4
80x80x32, 6700 RPM, 59.6 CFM, 0.68 inH2O, 47 dBA
So replacing the rear fans with the iPPC 3000 (43,5 dbA) doesn't buy you any sound help except maybe that it's PWM.
The NF-F12 midplane fans are..
120x120x25, 1500 RPM, 93.3 m^3/h (54.97 CFM), 2.61 inH2O, 22.4 dBA ... 1/3 the CFM (per fan) but double the pressure, which helps suck air around/past/through the drive bays and restrictive backplane.
If you're hammering your drives and need the raw CFM, yeah, it's not going to be quiet. Remember, though, that the above are based on hot SAS drives running hard in a production environment and generating 24 bays worth of heat for hours on end.
Using the older 846 "24 SATA chassis" as a reference the midplane fans are ...
Midplane: FAN-0127L4
80x80x32, 7000 RPM, 72.5 CFM, 1.09 inH2O, 53.5 dBA.
In that situation the NF-F12 is 2/3 the CFM and more than double the pressure, but 22 dBA vs 53.d dbA is a huge difference. Again, note that those stock fans are built for running hard and hot in a production environment (probabaly with 7200 RPM drives) which may or may not be the same in a situation where you're trying to make things quiet (eg, home or small office.)
As I'm running 5400 RPM drives on a home-schedule, losing 1/3 CFM but gaining pressure and noise reduction, for me, is a big win. It may be that the pressure is overkill (since pressure ratings kind of "cap out") and I'll need more CFM later, but for $75 in fans I'm willing to explore. =)
TQs will likely run cooler (SOTP, no numbers) because they're dumb with fewer electronic components than a SAS expander.
-mox