Sticking strictly to Red Dot/Promo:
They are great target loads for 40 S&W. My favorite load is 4.0g under a cast and powder coated lee 410-175-TC which weighs in a 180g. The bullets are seated to where the cone touches the rim (1.100" COL).
I get low to mid 900 fps out of a 4.25" M&P 40 with extremely low single digit std. dev. and very consistent POI at 10 yards. This produces a mild 26,000 psi (Quickload estimate) so it's not rough on the brass or chamber but the pressure is high enough that Red Dot burns very cleanly and completely.
I've tried as much as 4.0g Red Dot in 9mm with both the Lee 356-120-TC and TL356-124-2R seated long (1.135" with the TC and 1.169 for the 2R). I get 1100 fps out of each and good burn, but these are max pressure loads and I have better powders for medium speed 9mm rounds. I need 1100 fps out of these bullets to get good cycling and ejection of cases from my guns (M&P fullsize and Beretta 92FS, lower velocities are fine with my Shield).
The reason I've done so much testing with Red Dot is that I buy it by the 8# jugs for shotgun loading and using a half pound here and there for fun does not make much of a dent in the stash.
While Red Dot does not give maximum velocity in 40 S&W, it is an excellent powder for medium speed loads and gives very consistent velocities which should lead to taking the load out of the accuracy equation.
I also have to thank bds for all the valuable information he's posted on Promo. I learned a lot from them.