The condition that makes it useful is the condition that makes it fail. An ordinary order can be met by several counterparts at several prices, filling in pieces until it is satisfied or until its price condition stops it. A fill-or-kill order forbids that. Everything it needs has to be available at one instant, at prices its limit allows. On a security where the resting size at any single price is modest, the ordinary result is that the order is cancelled untouched. That is not a malfunction; it is the instruction working. But it means an investor who reaches for fill-or-kill in order to avoid a partial fill has usually traded a small, manageable problem for a larger one, which is holding no position at all.
The entirety condition also changes how the order interacts with the venue. In the rules read for this page, a fill-or-kill order sits in a small group of what the exchange calls contingency orders, alongside all-or-none and stop orders, and those "will not route". An order that cannot be routed away has to be satisfied out of that one venue's own book or cancelled. So the pool of available size is not the whole market's displayed size but one venue's, which narrows the odds further than the entirety condition alone would suggest.
All-or-none carries a simultaneity requirement that is easy to overlook. The same filing adds that all-or-none orders "will only execute against multiple, aggregated orders if the executions would occur simultaneously", and explains why: because of the size condition, the pieces have to be satisfied at once to avoid a priority conflict on the book. It also records that all-or-none orders received before the opening process or after the close are rejected. Both facts point the same way. An entirety condition is not merely a preference the venue tries to honor; it constrains the matching itself, and the venue would rather refuse the order than partly fill it.
There is a middle instruction, and it is being withdrawn on at least one venue. A minimum quantity order sets a floor rather than demanding everything: it "requires that a specified minimum quantity of contracts be obtained, or the order is cancelled", and like all-or-none it is treated as immediate-or-cancel. That is the instruction most investors actually want when they say they do not want a token fill, because it accepts a large partial while refusing a trivial one. The exchange whose rules define it proposed to stop offering it, saying the order type "is not utilized frequently on the Exchange" and that it was dropping it for lack of demand. So the practical menu at any venue is narrower than the concepts, and which of these instructions a particular broker exposes is a question about that broker rather than about the rules.
An all-or-none instruction takes the order out of the execution-quality statistics. The monthly order-execution reports brokers and market centers publish under Rule 605 cover "covered orders", and 17 CFR 242.600(b)(27) excludes from that term "any order for which the customer requests special handling for execution, including, but not limited to, orders to be executed at a market opening price or a market closing price, orders to be executed only at their full size, orders to be executed on a particular type of tick or bid, orders submitted on a 'not held' basis, orders for other than regular settlement, and orders to be executed at prices unrelated to the market price of the security at the time of execution." An order that must execute only at its full size is squarely in that list. The consequence is that the class of orders carrying an entirety condition is invisible in the published statistics, so there is no aggregate evidence about how well they are handled.