Thought I hated it all until fairly recently. Homemade mayo can be OK. Japanese Kewpi mayo is pretty good. Still, I rarely put it on anything by choice.
I generally don’t like it. If I get a sandwich made or something I’ll ask for no mayo. Most restaurant/chain mayo sucks. Heavy on the oil and other things that mess up a flavor I’m not keen on in the first place. There are some things that need it, like egg salad, and that’s fine. I don’t mind adulterated versions like chipotle mayo or sriracha mayo. However, if it’s a good mayo, it can really make a sandwich, especially if there are complementary ingredients like avocado.
Arctic Circle in Utah gave out fry sauce (aka fancy sauce). It's just mayo and ketchup, but it was so popular all of the local chains started providing it as well (McDonald's, Wendy's, 5 guys). The better ones generally splash a bit of BBQ as well.
There are several sandwich shops I just don't go to because they only use mayo and mayo is disgusting. But I do like other mayo based things like potato salad and deviled eggs.
A microscopically thin layer on a few select sandwiches is appropriate and delicious to me.
Anything more than a teaspoon and it becomes overwhelming and cloying.
I really think for the most part, mayonnaise has become a crutch for bad cooks. You really do not need to just add essentially pure fat to make food taste good, that's not necessary unless you are lazy and cheap.
I find eating excess amounts of fat and oil to be disgusting and nauseating.