Regionally popular brands of jarred mayo have slightly different recipes, and depending on which one you are used to, your salad recipes may not taste "right" when made with a different brand. Everyone has a family recipe that we get all in a twist about if anyone varies the recipe at ALL.
Miracle Whip was purposely designed by Kraft to be a cheaper mayonnaise substitute (because it doesn't contain oil), and has run ads comparing their flavors for decades, which is why people associate them.
Personally, I'm not super hung-up on mayo perfection, and will generally eat any decent brand of it put before me, but I do notice the different flavor notes. My own preference, like most Americans, is for the brand I grew up with, which in my case is Blue Plate. I can't get it where I currently live, so I'll usually go with Dukes nowadays, but Hellman's is fine, too, and even Kraft is acceptable. I don't like MW because I find it very overly sweet, and I probably wouldn't want any really sweet mayo, either.
I've heard from a lot of people that they really like Kewpie brand once having tasted it. Kewpie is Japanese and uses only the yolks of the egg; supposedly it has more of a umami note than most American brands. All I know is that it's very comparatively expensive unless bought at Costco, but I don't use enough mayo to buy that size of it. (I'm quite a warehouse shopper, but I just can't buy anything there that I know will spoil before I get halfway through the container.) As it happens, Blue Plate is also a yolk-only recipe, so it's more in this style.