That's a very good question, @MikeHunt !
"Is there really that much difference in reality between the "Acceptable" and "Best" above in terms of the uplink positions in the stack?"
That recommendation is focused on resilience / fault-tolerance aspects. The idea here is all other stack members still have a path to Core if any member switch is powered down or doesn't boot. That's why you shouldn't connect your uplinks to the same stack member. This would bring you to the acceptable scenario.
Now the Ideal scenario is the last where any pair can be down and still the remaining switches have an uplink to Core. Like you said, bandwidth and latency aren't a priority here; it's more about fault-tolerance.
If you found this post helpful, please give it kudos. If my answer solved your problem, click "accept as solution" so that others can benefit from it.