Theoretically you can.
For example would you put 6' camper with 7' cabover on short bed pickup - that could overload front axle.
But such combos don't exist.
Coming to your actual question, there is no specific distance where placement of COG makes it bad or good. It is combination of weight.
On practical note - you simply need to weight rear axle to avoid overloading and then different track handle tall and long load differently.
My long camper has COG about 65" behind the cabin and Ford dually handles that just fine.
