At lower rpm like what's normally seen in a pc, SP fans are opposites to CFM fans. Think of a hose, turn it on and you get a lot of water, but little pressure, so that water really has no reach. Stick your thumb over the end and now you get a ton of pressure, lots of reach, but water volume is limited. SP fans have a specific type of blade, designed to force air, CFM fans have a different blade, designed to move air, very big distinction. There are many fan models that will take partially of both designs, so you'll get a fan with acceptable SP and acceptable CFM, but nothing spectacular out of either. These fans are generally used as intakes, especially stock case fans, as they'll have to do double duty of moving a considerable amount of air, as well as getting that air through obstructions such as the hdd cages. CFM fans are much better suited as exhausts as they'll move a lot of air out, with relatively little need for SP.
How a fan works is backwards to common usage. The blades spin, creating a vacuum in the front. The byproduct is the flow of air out the back. The higher the CFM, the larger the area of vacuum, the more air gets moved. SP fans work on the same principal, but having lower draw, but higher force. This makes them better suited for things like radiators. CFM is still important, still need to exchange hot air for cold.
Another important distinction is the outward cone. Many CFM fans have a very wide cone, upwards of 120° in a giant 'V' out the back. This helps spread air around, the gentle breeze just helping displace any hot spots. SP fans have a much tighter cone, almost perpendicular to the fan, so much so that the NF-F12 is rated as a force-flow direction fan, all that air in a 10-15° cone, so really hammers anything in its way. The Scythe GT's are very similar in that respect.
More important than fan type, is ability to flow air in the case. If there's a bunch of obstruction in the front, a higher SP fan will do better, a higher CFM as exhaust. If (like me) there's nothing in the way, high cfm for both works great.
Speed balance is a pain to figure, unless all the fans are identical, it's semi impossible to get accurate. For instance, if you have combo fans in front, 50cfm @1200rpm and cfm fans out back at 75cfm @1000 rpm, then you'll have similar characteristics around 100% front, 80% exhaust speeds, regardless of actual speed. I have 2x 140mm on my rad intake and 2x 140mm as top exhaust. The rad fans run 450-700rpm, the exhausts run 500-600rpm, both sets max out at 1000/1200rpm, but I don't need the volume, so run my pc silent, which has little affect on temps, so no need for max rpm. Set by manual fan curves in CAM and SpeedFan.
1 thing about cfm, it's measurable. You can do it several different ways and still get accurate results, as defined by standards. SP is somewhat different, as there's no exact standard of measurement. So one company might measure with the fan 90° to 2mm distilled water on glass, another company might measure with the fan at 80° tilt to 3mm tap water on stainless steel. So the exact SP figures aren't entirely specific when comparing to different brands. Not knowing exact coefficients etc 2.0 on one fan could easily be far better pressure than 4.0 from a different company, but 4.0 from a corsair SP120 will be accurate when compared to 2.0 on a corsair AF140 as an example.