for your info -varible pitch props are now available for even small electrics .
All of the basic theory you keep repeating is of course true - but you seem to be stuck in first gear -
The static data is relevant -if you know how to use it -
I will give you a clue:
On full scale aircraft engines - they are tested after rebuilding --with a large fan/prop load .
the engine is anticipated to turn this load at X rpm - that proves that the engine is producing the intended power.
We do the same thing with our static test setups but we look at thrust delivered per watts of power input.
carrying this one step further - one can read thrust at various rpm PLUS watts of power to produce this thrust.
This info tells you what power you have availabe at various rpm under load.
Now you can plug in a calculated pitch and diameter of prop -along with slip etc. and get ball bark info.
Having done this sh-t for years -I know about which type prop will work for any given task.
BUT here is where theory simply becomes guesswork: (not uncommon)
the inter-relationship of prop/power and the airframe can and will skew the "best prop theory - badly ,in some casess .
So please stop with the "static tests are meaningless parroting"- they may be to you -but if you could learn how to use the info , you would find it worthwhile.