The way I see it, there’s two ways of looking at it
Video game collection Arthur who has two types of every possible sidearm, each fully upgraded and made of solid gold (unlikely)
Or Character Arthur who would just stick with a cattleman revolver because he’s not one for style or flash.
In my opinion, he just keeps the starting Cattleman as his main arm, and switch off hand sidearms with whatever powerful revolver or pistol he finds or buys at the time. So for example, when he finds the Schofield revolver in the Odriscal business in valentine, he uses that as his off hand weapon until he finds another weapon he likes.
And at the end of the game, his classic cattleman is all fancy looking, maybe with silver plating and the heroes pearl grip (which I might add, is only available for the cattleman.)