It’s a popular powder but in handgun loads I find that it makes for snappier recoil and a sharper report than other fast burning powders. Compare shotshell load data for Red Dot and see what you think. Green Dot burns slower and may be suitable for heavier loads.
The only shotshells I load are for cowboy action; they are low recoil shells with 7/8 ounce of shot. No need for anything stronger in that game.