The amount of throttle roll-on should depend on where you are in the turn and what you're trying to do. The portion of a turn where riders speak of 'maintenance throttle" is a place where you're trying to preserve the speed you have, stabilize the bike and achieve weight distribution appropriate for each tire. The acceleration is slight, like a top gear roll-on on the freeway.
In this part of the turn, you'll be carrying the most lean angle and the effect we're talking about of positive throttle reducing the cornering load (in addition to weight) on the front will be most pronounced. Once the rider sees the corner exit, begins to stand the bike up and start the real drive, you're right that the throttle provides less relief on cornering load because the bike is more upright, but at the same time there are far lower demands on traction at the front anyway because the line is straightening out. People sometimes run wide by overdoing exit acceleration, but I can't think of a time where I've seen someone lose the front this way.