There are many different kinds of lube out there and they all have their own pros and cons.
Water based lube
The most common type of lube, and the safest one for all kinds of sex. Might dry out quicker so be sure to reapply!
Silicone based lube
Generally lasts longer than water based lube, but destroys silicone toys so be careful if your using toys to prepare for anal sex.
Oil based lube
Not recommended. Although it's easily find around the house, oil-based lube can damage the latex in condoms and cause them to break.