Can depend a lot on the case. In my mITX, it's very crowded, and extremely tiny (think size 10 shoebox small), so static fans work great, much better than airflow fans.
It's a matter of need really. Cfm is just the volume of air moved, SP is how hard that volume is moved. So SP can be very good as low intake, they'll get the air moved to the gpu, even if it's less cfm than a cfm fan, except a higher % gets there.
But when using a top mounted aio, many times it's cfm that's better, flood the case and let the aio fans do the work. Same for the more specialty airflow cases like the Fractal design meshify C, 3x intakes, 1x exhaust, enclosed. Flood the case, let the exhaust move the air.
Most cases benefit from a more balanced design at intake, higher sp than a airflow fan, higher cfm than a sp fan. The old Noctua NF-P12 is a good example, as is its successor, the A12x25.