It is a very dependent subject on what your setup is. It depends on gearing, horsepower, terrain, etc.
My truck has some good lowend grunt, somewhat low gears, and is rockcrawled. My converter stall speed is 1000 RPM. It works great for my setup. I have enough gear and lowend torque to be able to spin the tires offroad on any obsticle that I need to.
If I did not have enough torque or gearing though and I wanted to rockcrawl I would want a higher stall converter. You need to be able to spin the tires when you get in the hard spots not just get bogged down. So if you don't have enough gearing and you want to rockcrawl then you need to get into a higher stall converter so the engine can get into a higher RPM for more power before the converter stalls out.
I have seen several trucks with lack of gearing and converters that are to low of stall. You get them on a hard flexed out climb or something and they truck literally will not move no matter how hard you hit the gas because the converter has stalled out before the engine can make enough power to move the truck.
For stuff like mud though you want a higher stall so that you get into a good power band for the motor and let the motor stay in is power band easier (like drag racing).
It is all dependent on what you drive, where you drive, how much gear you have, and how much power you have.
Harley