It used to be that bigger is better, but there are diminishing returns, and manufacturers have started making quiet fans in all sizes
[Edit]
To be clear, if the case you like happens to have 140mm fan bays, that's fine, but no need to specifically look for that.
Where do you get these numbers from?
Take Noctua fans for example, which are arguably some of the best on the market. A 140mm NF-A14 PWM [1] does have a throughput of 140.2 m³/h at 1,500 RPM, while a 120mm NF-A12x25 PWM [2]does only have a throughput of 84.5 m³/h at 1,700 RPM. And that even with the NF-A12x25 PWM being a newer generation fan than the NF-A14 PWM!
[1]: https://noctua.at/en/products/fan/nf-a14-pwm/specification
[2]: https://noctua.at/en/products/fan/nf-a12x25-pwm/specificatio...
Additionally if you use a variable fan controller to reduce the rpm on the 140 to a point where its cfm or cubic meters/hour of airflow is exactly equal to the 120, or 5-10% greater than the 120 at its default rpm, not only will its pitch be lower, but its objectively measured loudness on a decibel meter will also be less.
You can safely use a fairly large passive cpu heatsink if with a 65W tdp cpu. Human annoyance noise from small DC fans increases as they get smaller (40/60mm size fans are perfect examples). A slow 140mm size fan can move quite a lot of air and very quietly.