At the risk of stating the obvious, for any given configuration (stab position, airspeed, AoA, etc) the force required to move the stab (whether supplied by the trim motor or the manual wheel) is a function of the distance between a) a line drawn through the stab pivot point, b) the centre of pressure of the stab and c) its C of G.
The designer's job is to do the sums and work out the optimum position for the pivot.
It's hard to see how moving the pivot way forward or aft of its current location would lead to any significant reduction in trim forces, even if possible from the structural point of view (which it probably isn't).