A more realistic test IMO would have been to set trim to takeoff position and hold stick pressure for Vy, Vx or some other arbitrary climb attitude which is what quite a few pilots are doing just off the runway below pattern altitude.
This is a valuable discussion, so please excuse me if I come across a bit pedantic. But this is basic aeronautical knowledge, not some crackpot theory. My comments are in general, not directed at you specifically.
Takeoff trim setting in most light aircraft is specifically defined as that trim necessary to
hold airspeed at Vx in takeoff configuration with no control forces. If you are flying a certificated aircraft, then a test pilot determined the correct marking for your aircraft during the certification process. That mark is not arbitrary.
If you are holding back pressure during your departure, then one of three things are true: A) you are slower than Vx; B) you have changed aircraft configuration (flaps, gear); or C) you are not trimmed for takeoff.
Pilots get confused about this because you apply back pressure to rotate. But you do that because condition A is true: rotation speed is slower than Vx. If you leave trim alone, the aircraft will accelerate to Vx and you will not need back pressure.
If you are trimmed for a specific airspeed (any airspeed) and your CG is within limits, when you reduce power your nose WILL drop to maintain airspeed, unless you actively apply control pressure to resist it. If you add power, your nose will rise. Again, basic aeronautical knowledge, not crazy theory.
Yes, every airplane is different. Yes, airplanes fly different as W&B varies. Yes, other factors apply to twins, canards, Lake amphibs, etc. But by all means go out and try it in your plane and see how it performs so you know for sure.