I don't quite enjoy mayo lately. I buy the 'real' mayo, as the light mayo is horrendously sweet. But even the real mayo, has very strong taste that it covers food's taste, instead of mildly accompanying it and enhancing it.
Is there any mayo that is mild, yet fully fatty?
Carbolysis, you could try adding appropriate seasonings to your mayo, like a few drops of chilli sauce, apple cider vinegar, if you enjoy tart tastes (the SCV also loosens the texture of the mayo, which can be helpful as a salad dressing). I've also added mustard, garlic, lemon juice or whatever I fancy really. If I will be loosening the mayo with a liquid, I use a small lidded jar to give it a jolly good shake, or if I'm just adding a dry flavour or equally thick paste, I just use a small dish and really stir it around until well combines.
I use mayo; usually Hellmans or Lidl for me (Lidl mayo won a recent blind tasting where the tasters were Hellman's fans - It was on tv), as a base for various flavours. I don't "transform" too much at any given time, so that I don't become bored of it, and if I don't like the outcome, I just don't use that combo again.