I have a border collie mix that has storm anxiety + Separation anxiety and we have been seeing a behaviorist for her.
The vet said that Noise phobia is something that often never completely goes away. They work to find a way to make it more manageable. Generally that is training + Meds
For us, we struggled with the meds. A lot of what is used caused negative reactions in our dog. We finally have found a combo that seems to work well which is a very low dose of Clomicalm and Clonazepam.
With training we have been working on conditioning her to a safe place (her bed). I've heard that a lot of dogs seek out bath tubs in storms. I was told that if she has a safe place, let her go and let her be there on her own.
We are also training for what we call thunder parties. When there is a storm coming, we turn on music, we get treats and toys and me and my husband play with them. We don't force the dog to join, but she gets mega praise if she does. It took time, but that can work if we start before the noise does.
I have a thundershirt. It did nothing for my dog at first, but now combined with meds, it seems to calm her even more. It is worth a shot. A lot of people say it works well for their dog.
My vet talked about counter conditioning with storm noises and treats, but didn't seem to into it. Not sure why. I've heard it can be very helpful.
Noise phobia is awful. I hope you can find some things to help. I agree about most of the over the counter options... they seem like a waste, but do smell nice
The key to all of it though is patience....