It's totally pistol-dependent - the 1911 needs to be run wet, lube all contact points and check weekly. It's not meant to fire dry.

I've seen a glock 23 that wasn't lubricated for 23k rounds, no function problems.

I believe the rule is that you use grease on points of contact that go straight across another metal surface (like rails) and oil on things that are round or rotated (like barrel bushings). I've never seen overlubrication hurt a pistol function, seen it on rifles, but not on pistols. Underlubrication is only a problem if the gun was designed to be lubed.