This is a decent article but beware of term confusion. The author says tight LSA cams have more low end torque but what he really means is that they have more mid-range torque. The low end torque (1500 to 2500 rpm) isn't very good when you have a lot of overlap. The author is looking at the graphs which start in what would be the mid-range for a street engine. So it really depends on what you are trying to accomplish. A race engine with a 5000 rpm stall converter will tolerate a tight LSA cam much better than a muscle car cruising to the Nats with the overdrive engaged and the AC on full blast.

https://www.hotrod.com/articles/camshaft-shootout-lobe-separation-angle-tested-explained/