Define "Ideal"??
We used to have a loose 8" that would stall 52-5400 behind the typical junkyard 284-484 440. You know, the kind of motor that was all done at 5800! 400-600 rpm is definitely not ideal, but it sure was fun!! It would usually be a tenth quicker, and 2 mph slower than the common 10" 3600.

If it's strictly a race car, especially a heavy one, how well the converter and torque curve match, may determine a lower shift point rather than raising the stall. 10% above peak torque rpm used to be the rule of thumb for stall setting, but I think modern agressive converters can be a little closer to peak, and deliver the best performance.