With a single unit it's possible to directly cool areas of the house that are down a hall or behind a door from the main area achieving better temperature balance. With a wall coil it only cools the area that has good convective air exchange with the room with the wall coil.
The turn down ratio is the ratio of it's maximum modulated output and it's minimum modulated output at a given temperature. In an SEER test the test condition is at a 15F difference between indoor and outdoor temperature, typically 95F outdoors, 80F indoors, which is usually specified in the submittal sheets (often in the foot notes.) This is different from the "rated capacity", which is the modulated level at which the efficiency was tested.
eg: http://www.younits.com/media/wysiwyg/Literature_PDF/Mitsubishi/MSZFH09NA_MUZFH09NA_Submittal.pdf
For the FH09NA the cooling Capacity range is specified to be 1,700 - 12,000 Btu/h, but the Rated capacity is 9000 BTU/hr. The test conditions are found in their "Rating conditions" list, where you will find:
*1 Cooling | Indoor: 80º F (27º C) DB / 67º F (19º C) WB
*1 Cooling | Outdoor: 95º F (35º C) DB / 75º F (24º C) WB
What this means is that running at full speed at a 15F temperature difference (say 91F outside, 76F inside) it can deliver 12,000 BTU/hr at some unspecified efficiency, but if modulating at 9000 BTU/hr it would deliver the rated SEER of 30.5.
But when it's operating at a lower output level it's efficiency will exceed the rated SEER as long as it's running continuously rather than cycling on/off.
Your cooling (and heating) load varies with the outdoor temperature and the amount of solar gain the house is receiving. The heat pump has to be sized sufficient to cover the maximum load, but the maximum load is much larger than the average load. With a modulating heat pump it will run far more efficiently at part load than if it's running at full speed, but that efficiency gain is severely blunted if so oversized that the minimum output is higher than the average load. For example:
Say your peak load is 15,000 BTU/hr at 3pm on a sunny day when it's 90F outside and you're getting a bunch of gains through the window, a condition which happens only 1% of the time. If your average cooling season load is 6000, BTU/hr when it's 82F and hazy, a unit that can deliver 24,000BTU/hr but with only a 2.5:1 turn down ratio only modulates down to (24,000/2.5=) 9600 BTU/hr, such as a 2-ton Carrier GreenSpeed, is less than ideal because at your average seasonal load it will be cycling on/off rather than modulating, continuously adjusting it's compressor & blower speeds tracking the load. If it's not modulating, it's not maximizing efficiency or comfort, even if it's running at pretty decent efficiency modulating on/off at minimum speed. A Fujitsu 18RLFCD can modulate between 18 down to 3100 BTU/hr and 20,100 BTU/hr which is a (20,100 / 3100= ) 6.5/1 turn down ratio. (see:
http://www.fujitsugeneral.com/PDF_06/Submittals/18RLFCD%20Submittal.pdf )
When the cooling loads are that lower than the 1% outside design condition (which is MOST of the time) it will automatically adjust it's output levels the 15,000 BTU/hr load at the 1% outside design condition with a decent amount of margin to spare. When modulating at 18,000 BTU/hr (it's "rated" output level) , it will be delivering it's rate SEER of 19.7, but it will run higher efficiency than that most of the time as long as it's within modulation range. When the cooling load is below it's minimum modulated 3100 BTU/hr it's efficiency will be lower than it's efficiency when the load is between 3100 BTU/hr and the average load of 6,000 BTU/hr, but at loads that low the efficiency matters less.\
Bottom line, its the minimum modulation level that limits the efficiency, which is not exactly the ratio, but a high turn down ratio gives you a wider load range to work with. You need a range with enough capacity on the high side to cover the 1% load with reasonable efficiency, but to maximize efficiency and comfort the minimum modulation should be an output level that's lower than the average seasonal load. When you get the sizing right it will be able run almost continuously for days or weeks on end without cycling, but at extremely high efficiency and comfort.