There are lubricants that can sting if you've any cuts, but unless you're looking at one with spermicide, no intimate lubricant is going to 'hurt you in some way'.
If you're going to go down that route, I'd look at the veg aisle before reaching for the hot dogs. And whatever you choose, put a condom on it.