With the exception of the 32 Mag, there is significant load data out there for what you are wanting to use the Red Dot in. As for working "well", I cannot speak to that as I don't use Red Dot, but I would offer that the powder has been around a very long time, is well known, and should offer no real problems so long as you use the load manuals and work up.
It is, however, a flake powder, so metering may be a bit iffy. I would think, though, that charges would be well within +/- .2 grains and maybe a bit better, depending on the powder measure...