Orion is overengineered for ferrying stuff to LEO and back. Too much propulsion, too much life support, etc. Why would anyone pay the extra costs for the capsules and for the heavy launchers just to provision a LEO space station?
Most Apollo flights were to low earth orbit
Narrowly, IF you count the unpiloted test flights. Otherwise it's 6 LEO flights vs. 9 BEO flights, unless I'm missed some.
And NASA used Apollo for LEO flights because the last Moon flights got canceled and they had to use up the stuff they had for something else (including the design and tooling, given that a new design would have been even more expensive).