I've used everything from Tetra-Lube to sewing machine oil. Anal lube is right out. Or so I've been told.
I do the same thing -- and when I'm hearing that I should be sparing with the lube on a particular gun, I'm afraid that that one will feel like I love it less.