140mm are quieter at the same rated CFM. but that only applies when comparing like with like.
With larger blades the motor has to do more work due to more mass it needs to spin.
Most motors were not optimized for the added weight so for the longest time 120mm fans even tho they were smaller would outperform 140mm variants in things like static pressure, due to a better optimization of motor and blade geometry.
You can't just slap a larger blade geometry and expect it to perform the same. Its like lets put larger blades on a jet turbine and see if it will go faster.
But 140mm fans have evolved a lot though out the years. I would most definitely use them for applications like a exhaust fan, or intake fans.
I would also use Noctua fans which come with Noctua heatsinks for 140mm class, as Noctua has pretty much optimized the blade geometry for it.
I would not use some unknown amazon 140mm fan which claims it can move air like a typhoon at the noise of a fly.
In general, for heatsinks, and radiators, i'll always stick with 120mm, as its just way more matured, and motors for them have been optimized for so long, even the guys who copy the fan tend to copy the motor design and blade geometry.
For exhaust, or intake, i'll be OK, with a 140mm, in almost any variant, as they will be quieter, and move more air because of the larger surface area.
For 140mm heatsinks, i'll only use a premium fan like a eK Vadar, or Noctua, as they have pretty much hashed out what needs to be changed on the larger size.
For 200mm fan, well, your in the wild wild west, so i would also try to stay with a reputable vendor that is known not to fudge numbers.