The Thermaltake Riing12 model you link can deliver 40.6 CFM max airflow generating 24.6 dBA noise at full speed, and can work with very reduced airflow up to a max backpressure of 2mm H20. It has a 1 year warranty. Newegg sells it for $11.54. It includes a single-colour LED ring that lights up when the fan is running, but it does not do some of the fancy changing lighting effects of the RGB fan types. I don't know whether you want that LED lighting feature.
If you do not want the LED feature, the Noctua NF-P12 redux-1700 PWM can deliver 70 CFM max airflow generating 25 dBA noise at full speed, and can work with very reduced airflow up to a max backpressure of 2.8 mm H20. It has a 6 year warranty. Amazon sells it for $13.90. This is a 4-pin (PWM fan, but a 3-pin version and a slower low-noise version (able to function against LESS back pressure) are available at virtually the same price. Noctua fans have a reputation for low noise compared to others and long life.
The Corsair Air Series SP120 High Performance Edition can deliver 63 CFM max airflow generating 35 dBA noise at full speed, and can work with very reduced airflow up to a max backpressure of 3 mm H20. It has a 2 year warranty. Amazon sells it for $22.92. It also has no LED feature, and is of the 3-pin design.
A couple general notes. A fan that CAN generate higher airflow against a higher backpressure at maximum speed general will NOT be run at that max speed because the mobo's automatic control system will slow it down to deliver only the air flow needed to keep your CPU's temperature under control. So a potentially "noisier" fan probably will not be that noisy under actual use. What it CAN do, though, is produce more air flow and cooling IF you need it for high workloads.
Many fans come with "Low Noise Adapters" that you can insert into the fan's power cord. All that does it reduce the Voltage to the fan so it runs slower and quieter, BUT at reduced air flow. These devices are useful IF your fan is NOT connected to the mobo for automatic speed control and is receiving a fixed full 12 VDC supply directly from the PSU. When you do use it under automatic mobo control, do NOT use that Low Noise Adapter - all it will do is limit the max performance of the fan. It will not give you low noise magically with full air flow.