I'm a huge fan of HS-6, the more I use it the more I like it. Like Skip said, the published data shows it will deliver high velocity with lower pressures than other powders of a similar burn rate. I've found it delivers high velocities without any signs of high pressure. It's a very clean powder if loaded up near the top end of the charge range. I use Magnum primers when loading with HS-6 and have found Magnum primers will shrink the SD numbers to single digits. Most of the older loading manuals recommended use of Magnum primers with all 3 HS powders. (HS-5, HS-6 and HS-7) All but HS-6 are now out of production. BTW, HS-6 = W540 and HS-7 = W571 so if you find an old recipe with those powders you can directly substitute it's equal powder. I've used HS-6 with my .38 Special +P, middle to middle heavy range .357 Magnum, heavy .45 Auto and .45 Colt working loads with very good success. You can push your 40 S&W loads up to higher velocities with HS-6, you will like the results. HS-6 works very well with lead bullets but will also work well with jacketed bullets as well. I guess you can tell I really like this powder...
Hope this helps a bit...