Brad,
If you get a prop pitched to not exceed your engine limit (usually 2700 RPM), you wont have to worry about limiting your throttle, except to save fuel. I originally had a fixed pitch Sensenich metal prop on my RV4 that would turn 2900 RPM at full throttle - at any altitude up to 12,500’. I replaced that prop with a ground adjustable carbon fiber Sensenich prop that I’ve adjusted to protect my 2700 RPM Lycoming engine limitation. My takeoff roll actually is less with this prop, but my second segment, and enroute climb performance is slightly less - but still pretty good at 1500+ fpm. However, cruise performance and efficiency is better.
If your goal is short takeoff and initial climb, then a finer pitch is what you would want, with the understanding you would likely overspeed your engine in cruise at full throttle and be giving something back in cruise speed and efficiency.
Think of it like this..... do you want your airplane to be stuck in 5th gear all the time (cruise prop)?, or do you want it to be stuck in 2nd gear all the time (climb prop)? Or, do you want it somewhere in between? Catto can make you a prop that will give you whatever ‘gear’ you want to be stuck in (fixed pitch pain). My ground adjustable will allow me to change my preference - which I don’t intend to do now that I’ve found my sweet spot. The only thing you should be concerned with at this point, in my opinion, is over speeding your engine. If you are at half throttle at 3000’ and seeing 2700 RPM, and you got there in one minute, you are leaving cruise performance on the table. And that’s fine if your goal is exceptional takeoff/climb performance. If you want to go somewhere fast, get a different prop.
Also, if you have a metal Sensenich, it can be re-pitched. It takes a couple gorillas with a long bar, but an experienced prop shop can do this. They should also do a new dynamic balance for you after this change.