I went through exactly this choice some 2.5 to 3 years back.
Powder was scarse, hard to find anything other than slow rifle powder.
I did not expect one choice to be the best at everything. But it had to be able to function in every caliber I load for. When the time came to choose Unique, bullseye, etc were not to be found at all. I was able to get quantities of Red Dot at 3 times in the last year.
It works well in my pistols, from 7.62x25 to .45 acp. Shotguns are a slam dunk.
And I quickly found that as long as I did not expect it to cycle the action of semi auto rifles. That it would work just fine for light loads. Now mind that a light load of 13 grains of Red Dot behind a 310 grain gas check bullet in a .444 is nothing to mess with.
My favorite load seems to have settled in at 4.6 grains. It seems to work in everything. .223, .300BO, .357 mag, 7.62x39.
Sitting on a nice big pile of Red Dot, with lots of primers in the box has me sleeping really well at night.
I am as ready as I can be for whatever comes.