As we age, the right lubricant is the difference between pain and pleasure for both partner sex and solo sex. These differ widely by feel (how much slickness, whether it feels natural, for example) and duration (how well it lasts before getting dry or tacky), so it's good to start with information like Corey's.
Your neighborhood drugstore offers just a few of the dozens of brands available, so don't limit yourself. If there's a woman-friendly sex shop near you, plan to hang out and, one at a time, rub a drop of a few different lubes on your hand (no, no fair to try take the tester bottle to the bathroom with you) and see what you like. If taste is important, you can, uh, lick your hand.
If you're not sure what you'd like and there's no convenient place to find out, try buying small samples of a few different types or a sample pack, available from many online sex shops such as Good Vibrations. Enjoy!