KenV,
Hi, actually you can order an A330MRTT with Main Deck Cargo door, yes the French have ordered them on their second batch of 6!
Not sure what you mean about the low Nose-wheel Gear problem. Many airlines daily seem to manage to load and offload Pallets and ULDs without any issue! They have Hi-loaders that adjust for height you know!
You may be correct in saying they are too big for every occasion, but they would sure replace a KC-10 quite well.
I would have thought a mixed fleet maybe the best for USAF in reality.
