After trying a bunch of different lubes over the years, I settled on ID Glide. Lasts well for a water based lube, relatively easy to clean up, doesn't have a funny smell or cause irritation for me.
http://www.bigsextoystore.com/cgi-bin/edatcat/BTSstore.cgi?user_action=detail&catalogno=ID-GLI35Note that I prefer the regular ID Glide...NOT the "Pleasure Sensual". I tried that, and found it mildly irritating.