I've used several products for this purpose & have come to the conclusion that most are perfectly adequate. Some may be better than others, some may be cheaper. If you have some difficult-to-meet requirement, the super-dooper lube/oil/grease may be just the ticket. No need to agonize, IMO.
I have yet to find, however, the lube/oil/grease that can stand up to 5 day/week, 12 hour/day IWB carry in the Texas summer without a re-application. They all wear/wipe off and then rust if you don't watch it. Humidity & (my) perspiration are a killer on the finish in a few days' carry. I worry about finding the time to PM on a bi-weekly basis instead of the finding ultimate gun oil (which is gonna wear off by Wed anyway). Then...I can worry about chambering the rounds too many times, rotating carry ammo, and the rest.
Whatever you do, just be sure NEVER to cross the anti-WD-40 mafia.