How much stall is to much for a mainly street car

It all comes down to how much torque YOUR combo is gonna make in that 2000 to about 3500rpm zone, and how hard the engine is gonna have to work at getting YOUR car moving, and how much tirespin you want,lol.
What it's not about is how much Absolute Power the combo is gonna make.
example
A stock Low-C teener, with 3.91s doesn't need much TC. But if you up cam it with a 340 cam and X-heads, well it's gonna want more stall, AND more gear...... because the low-rpm torque kindof went on vacation.
For your streetrod, you can substitute a little higher stall for maybe 1 or 2 cam sizes, cuz by your description of application, you're not gonna need a whole lotta top end power.
Also, a bigger engine will inherently make more low-rpm torque, so again, not a lot of stall is needed,nor a lot of gear.... unless too big a cam was installed for the application.
Also, the more cylinder pressure an engine makes, the stronger will be the low-rpm torque again.And this actually turns out to be a pretty good measuring stick; cylinder pressure and cubes.

So the trick is just to install the biggest engine you can find and max out the cylinder pressure for the available gas and cam it to operate in the zone you need it to, and gear it for the speeds she is gonna be seeing most; Shazzam!

Ok now starts the compromising;
budget,multiple-use biasing,available gas,,, today and years from now,yada,yada,