I will preface my comments on primer with an axiom: If you cannot sand the primer and achieve a perfect feathered edge, it is complete garbage.
These are the primers I actually tried over the last three years:
Model Master Light Ghost Gray enamel, in the old formulation, was fantastic stuff. Back when I painted with Model Master enamels, before the formulation change, I did not prime because it was unnecessary. That stuff was extremely durable. Around 2017 the Model Master enamel paint formulation was changed to meet a new California law. The entire paint system died not long after. That California law would go on to kill a bunch of paints. Anyway, when I switched to acrylic paints, I used old formulation Model Master Light Ghost Gray enamel as my primer until I ran out.
Mr. Surfacer is excellent primer if you do not mind the fumes. The resulting finish is very durable and sands very well. It is my go to primer for sealing putty work. Use a high quality mask with this stuff. If I was immune to chemical damage, I would prime everything with Mr. Surfacer.
Badger Black Sneeze (or whatever it is called) Primer is an excellent acrylic primer. Once dry, it sands quite well. White Sneeze is garbage that acts like shrink wrap and comes off in sheets when sanded. I cannot say what other Sneeze primers do because I have not tried them. I have read other users claim that White Sneeze eventually dries and becomes hard like Black Sneeze. If that is so, it takes days and a primer that takes days to cure is garbage.
Vallejo Acrylic Primer is garbage in Black, White, and Primer red. Those are the three colors I tried. It acts like shrink wrap and comes off in sheets when sanded.
…
Here I go off the rails and shoot the breeze…
As a rule, petroleum solvent based primers will be significantly more durable than water based primers. The most amazing primers of all are a kind of two part epoxy. They need to be mixed in batches and sprayed immediately. When I did research on this subject, epoxy primers topped the charts for durability by a wide margin. They are widely used in automobile production. However, unless you plan on putting your models out in the sun and weather full time, such primers are very probably over kill. (If you want to make a model that will last a thousand years, well…)
I suspect the best bang for the buck, durable primer for a model builder is something like Rustoleum Enamel Primer decanted into a bottle, thinned, and sprayed with an airbrush.
…
One last comment. No one has tried every single primer. No one has performed some massive, double blind, primer experiment with completely controlled variables to determine what is objectively best. Every single person in this forum mucked around with a bunch of different primers and eventually settled on a personal best. You will very probably go through the exact same process and your personal best may change as you experiment or your needs change.
As a model builder, I assert that it is always to your long term advantage to experiment with new things. It costs money. It may cost you models. But the knowledge gained will allow you to make better informed decisions in the long run. Of course, experiments can be costly and painful and each of us has a personal tolerance for that.
I will finish by adding that my skills are modest and my experience is far behind some guys who frequent these forums. However, I can write long, wordy, boring posts better than most.