I hear ya, OP. I've been down this road.
For me, it's not that I don't want to shoot them... it's that I get horrified if I'm shooting with someone else and they accidentally bang them around in to something... each other, the table, a nail head on the table, whatever. I also fear holster wear on guns that aren't my carry guns. (my carry guns are tools and I have no struggle with them)
Also, it's not like some of my guns are horribly rare or valuable -- it's simply that I
really like them and don't want to see them get worn.
I still shoot them. I try to clean them with care. (lots of guns are beaten up while "cleaning.")
Guns I don't shoot? I have a family heirloom that I don't ever shoot anymore. I have shot it, and anyone in my family that wishes to shoot it shall be able to shoot it if they want. For me, it's simply that the nickel finish on this 88-year revolver doesn't want to go through more shooting and cleaning without wearing even more.
I bought a similar revolver (circa 1982) so that I could shoot something
like it instead of shooting it. That works.
A gun that I bought and refused to shoot? Yep, I did that once. It was unfired outside of the factory when I bought it for an absolute steal and my plan was to flip it. I fawned over it for many months and then sold it for a juicy profit which completely funded another handgun that I had been pining over. I'm bummed that I never got a chance to shoot it, but part of my sale "feature" was the simple fact that outside of the factory, it had been neither fired nor field stripped. I had hoped that would add to the sale and I wasn't about to make up a lie, so I never got to shoot it.
My buyer got a really great deal on an expensive pistol that was every single possible bit as good as new, but he got it for a price that ANYONE looking for one would have been out of their mind to pass up. And I had the fond memory of owning it for a while... and I bought a pistol that I've been shooting the heck out of since I got it.