I've used a mix of olive and coconut oil in a mayonaisse and it stayed failrly light and fluffy in the fridge. I also made mayo out of bacon fat once and it was delish!
It's fun to try different oils and get different flavours - just make
small (1cup oil, one egg) portions and experiment!