First off Brian, Your pictures are beautiful! Especially that engraved Colt Single Action Army! That's basically what I'm looking to do. My wife wants me to photograph my whole collection, along with providing descriptions and value estimates. In case something were to happen to me, so she wouldn't get screwed over trying to sell anything or everything.
I always try to keep the latest S.P. Fjestad Book Of Gun Values on hand. But that can get confusing to someone who doesn't know guns, conditions, etc. So that's the main purpose for this camera. To provide something better than my little 15 year old Sony Cybershot can. I suppose I'll need Macro. Do they all come with some type of Macro setting? ($500 to $750 range cameras, like the Nikon and Canon I posted?) From what I've read SanDisk memory cards have a pretty good reputation. Even the 128 GB seems affordable. And as you mentioned, an extra battery sounds like a necessary investment.
I don't need high speed for video. Just something for basic short video's. (Stuff like my dog, or me at the range, etc.) Nothing like capturing auto racing, or anything like that. My old Sony will shoot "video". If you really want to call it that. It makes the first motion picture of, "The Great Train Robbery" look high tech. And it only lasts a few seconds. So whatever I end up with will be a massive improvement over what I have now.
First off, thank you! That's very kind. One of the added benefits of having a camera with a larger sensor and a lens with a large aperture (smaller f number) is the ability to blur out the background so your eyes go to the main subject (in this case the SAA in the front).
If you're looking for macro in an SLR you are looking at getting an upgraded lens with a good macro range or a dedicated macro lens. One of the benefits of point and shoot cameras is they usually have a macro setting built-in that will allow you to focus very closely. Olympus is famous for this because they are, at the end of the day, a microscope company.
SanDisk memory cards are all I use. Never had a problem with them. Still, backing up all your images to a couple of places is a good idea. What is it Michael says? All things made by man break eventually.
USB charging - Some cameras can. Some cameras can't. Just a matter of doing your research.
WiFi - Full disclosure, I'm addicted to WiFi in my cameras. Especially the Olympus. It allows me to control the camera remotely, change settings, even zoom the lens with my smart phone. Once the photo is taken it can be transferred to my smart phone for immediate upload to social media or Flickr. Some cameras are more capable than others in this regard.
By the way, your photo of the Ruger is REALLY good!