A compressed charge of BD in 9mm can give some good velocity. Max loads in 45 auto do it, although the newer powder Power Pistol is a better choice IMO
And I haven't seen the pressure spikes in BD associated with temperature, although I don't doubt that its possible. BTW, I have heard it both ways: that is, that BD spikes in cold temps, and then from another source that says BD spikes in high temps.
But I have experienced spikes in pressure when using magnum primers and also when you try to load it too hot. Some powders like H110 have a more "linear" rate of increased pressure as it relates to the velocity of your loaded bullet. IME, Blue Dot hits a point where the linear character of loads disappears and you head into high pressure spikes and need to back off.
So in 9mm loads that run ~30-35k CUP Blue Dot runs well. Same for 45 Colt in 30k psi loads... and 44 mag, 41 mag, etc.
But when you try to load it in 50k+ psi loads it gets "hinky" quick. 9x23 Winchester is better served with Ramshot Silhouette, VV 3N37 and AA7.
And in 454 loads that run to 55k I prefer 2400, AA9, VV N110, H108, and H110/WW296.
Like I said previously, there are better powders for specific loads, but IME BD is a good all around powder for med to med-heavy loads and if I saw a great price on BD I wouldn't pass it up.