I have spent hundreds of hours developing the max power 9mm load.
The limiting factor is the case is full, pierced primers, and bulged or blown cases. [I use a trigger string. Blown cases are expensive and dangerous.]
I recently developed loads with the following powders for 9mm 124 gr:
Bullseye
Unique
Power Pistol
HS-6
Blue Dot
2400"
3N37
800-X
AA#5
AA#7
AA#9
H110
LIL'GUN
Long Shot
I found, with my primitive pressure measurements, that Power Pistol win the performance contest.
In 147 gr 3N37 wins.
In gun destroying case falilures, AA#5 is so far past Bullseye, it just shows most people's intuition is wrong on this subject.
The recoil in a small 9mm can be worse than 44 mag full house loads. This makes 9mm nuke loads acedemic, as a normal person cannot take the recoil.