I'm a cheap SOB. Mobil 1 has worked fine for me, and one quart from the auto parts store will last a LONG time.
That said, I've never had a gun malfunction because of lube, regardless of what I've used. I just make sure they're properly lubed and shoot the heck out of them.