For me, a "mineral oil" product is much preferred.
An example is "baby oil" products especially with Vitamin E and aloe vera.
This helps not only in "lubrication" but in maintaining skin health.
Next, there's nothing wrong with using a water-based personal lubricant such as the brand name "Astro-glide".
Silky, slick, and VERY effective as a lube.
I avoid at all costs lotions, soaps, and virtually all of the others listed in the poll. Many of these "agents" have very caustic ingredients to skin (when used over time).
To (repeatedly) apply them is going to lead to rashes and irritations for many.
As to mayo (?) Ummmm.... Nope. I don't think so.
"Just hold the mayo" for my sandwich!