Like I'm sure a lot of us here, most of my collection goes unused for long periods of time.
So whenever I clean any of them, I do a very detailed job and finish up with a very liberal coating of protective oil (I like Slip 2000 but any good gun oil will do).
Then before I take one out to shoot, I just run a single dry patch through the bore and cylinders (if revolver), wipe it down with a clean towel, and go shoot.
The idea that too much oil will cause excessive wear is nonsense. Where that might come from is that excessive oil can hold more dust, grit, and bullet residue to where it could turn into an abrasive paste. But that simply won't happen if a person cleans the pistol after a day at the range.
Here's a short anecdote from just last night: I hadn't shot my Dan Wesson .22 revolver for quite a while so I thought I'd take it out and give it a onceover.
I immediately saw that there was a white powder inside the front ends of all the cylinder holes, so evidently, it had been so long since I'd cleaned it that what I think happened is that the little lead residue that remained started to oxidize.
If you pick up a lead bullet that you've overlooked at the bottom of your shooting bag for a couple of years, you'll probably notice that the lead itself is coated with a white powder, and that's what was inside the chambers of my DW .22.
So even when you slobber them with oil, that's not a permanent storage solution and they still need to be looked at once in a while. Of course, the stainless ones are probably less critical, but I generally like to re-clean a pistol at least every year or so. This DW had been at the back of the safe for probably 5 years untouched.