Randomness of quality of loot in locked key rooms is annoying if not broken at times

I understand that it's meant to be random but the value of the loot for keyed rooms especially the same keyed rooms is broken imo. Normally I choose not to whine and accept things as they are but this one actually drove me quite insane. Stella Montis security checkpoint is a prime example of how the randomness of the loot is fucked.

In the twice i've been to it, the first time my friend and I find a vulcano BP and complex gun parts BP with an osprey BP. The second time I go with my key I get 3 glow stick BPs and nothing else. Like wtf...??? What is the point of going into a key room if the loot can either be really good or terribly shit? am I missing something?