Airflow (measured in CFM) is good when you have unobstructed airflow path. E.g case fans.
Static pressure (measured in mmH2O) shows the actual strength of the fan to push air through obstacles. E.g rad fans or when fans are behind foam filters (including the ratsnest of cables behind fans).
Overall, high static pressure is better than high airflow, since when it comes to the PC cases, even the grille is considered as obstruction and impacts on the airflow of the fan. Not as much as rad does, but still, it is something.
Ideally, high airflow and high static pressure fan is the best.
E.g like Corsair ML120 Pro LED fans that i have in use;
specs:
https://www.corsair.com/us/en/p/cas...premium-magnetic-levitation-fan-co-9050042-ww
up to 75 CFM, up to 4.2 mmH2O. That is a lot for 120mm fan.
Though, mostly i have 140mm fans in use: Corsair ML140 Pro LED,
specs:
https://www.corsair.com/us/en/p/cas...premium-magnetic-levitation-fan-co-9050047-ww
up to 97 CFM, up to 3.0 mmH2O. Since 140mm fan moves more air and does it quietly than same spec 120mm fan.
Only downside of these Corsair ML120/140 Pro LED fans is their high price, which is mostly due to the mag-lev bearing they have (magnetic levitation bearing lifespan is essentially unlimited). Also, they don't offer unicorn puke either. Either single LED color (in one of my builds, i have red LED fans, in another, blue LED fans. There's white LED option as well) or no LED what-so-ever.