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...