There are three forces involved and each of them has a centre point in the longitudinal axis in a foilboard.
These are gravity (down), lift (up) and buoyancy (up).
One of the biggest reasons why sups fly badly and pump badly is the center of lift is too far back. As
@willow75 suggests, the best position almost always ends up being the front of the tracks. Even then it's still not optimal.
For a board to be in balance while flying, the center and gravity and the center of lift should be in the same place, or almost exactly. With a well balanced setup when unweighting both feet the board will carry on flying level. Pumping is much easier, 2 foot pumping is possible, and turning is much easier and smoother.
When on the water you want the center of buoyancy to in the same place as the center of gravity, or even slightly forward - this gives more stability on the water. A lot of SUPs tend to have quite a lot of volume further back. This means you have to stand further back to be stable while standing, which means you have to pull the foil further back to get stability while moving on the water. This lead to the center of lift being behind the center of gravity. So even smaller, minimal volume SUPs end up being unbalanced.
Rather a slightly longer bigger perfectly balanced board than a shorter board that's out of balance in this way.