Lube advice

I love using lube but hate the sticky after math. Any advice on what brand is best or if oil based is better than water? Me and my partner don't use condoms but iv never tryed oil based.

also if you have any recommendations on flavoured lube that isn't sticky please let me know.