You have two basic theories to deal with here. On the one hand is the engine torque & power output that varies with air density, RPM, throttle position, and fuel air ratio, and on the other hand you have the hull power demand that varies with hull configuration, weight, airspeed and AOA during various flight maneuvers.
The job of the propeller is to mate up the engine power curve with the hull performance curves. This is not an exact science because in the aviation and marine environments everything is a compromise, especially where fixed pitch propellers are concerned. This is why variable pitch propellers are available, of which the constant speed type is the most common. A fixed pitch propeller will never be as good at mating engine performance to hull demand under all circumstances of flight, there are always compromises. Add to that the air density can change over 30% during a single flight and it is amazing fixed pitch props work as well as they do.
If you truly want the best power available for takeoff and for cruise, then you want a constant speed variable pitch propeller. That will allow you to maintain maximum engine power regardless of airspeed during acceleration, takeoff and climb, and then to reduce RPM to optimize engine power for cruise at different cruise speeds and altitudes. IMHO to meet your goals nothing else will do. Everything else is a compromise and not worthy of your time and money.
The least expensive way to get this is to trade up to a different airplane. A constant speed prop is available on many used small planes. I traded up from a Cherokee 140 to a Mooney Super21, and the cost was very reasonable. In 2004 I bought a Cherokee 140 with 4400 TTAF and a zero time rebuild at 160HP. It had recent paint and a new interior and I paid $42k, a premium at the time.14 years later I sold it with 4900 TTAF for $32k and bought my Super21 with 2900 TTAF for $40K. So the upgrade cost me $8k but I got a better airplane in the mix. You don't have to go that drastic, a Cherokee 180 will do nicely. Have you priced an upgrade to a variable pitch prop lately? I'd be looking for another plane.
You said " I may be in the minority but I like as much power and acceleration as possible at takeoff. The down side of higher static rpm is potentially over revving in level cruise." You are not in the minority at all. You just don't have the right equipment to do it with. And constant speed props don't over-rev at cruise speeds.
I hope this helps.
