I don’t do wireless either. For vacations I have a DSLR and my wife has a point and shoot and I have Apple’s Camera Connection Kit --SD card slot to lightning adapter. I import photos at the end of every day on to my iPad which has iCloud Photo Library enabled so that the photos eventually make it to all our devices including Mac at home.
If you have more than a small batch of photos to transfer the wired solution is still the best way to go.
Camera manifacturers apps got better nowadays, but wireless connection isn’t that reliable, as far I can tell.
Apple’s Camera Connection Kit works a charm.
I’m on holiday at the moment and using a Panasonic LX100 which is probably 3 years old now. I think the Apple camera connection kit is the way to go but it is so expensive.
So I’ve been transferring wirelessly and it’s been good and fast. The Panasonic app was so slow but Cascadable has been really good. Free but with some paid extras. It seems to work for a number of cameras that create their own wireless connection but not Bluetooth as far as I can work out.
Being a freelance photographer I can relate to your wish for a better point and shoot --> iCloud solution.
However, after Apple added RAW support, and especially the last couple of years have made using the iPhone 7+, 8+, or X as a point and shoot camera a immensely great experience, and produce amazing results.
I went the iPhone only route a couple of years ago with my 6+, and switched to the 7+ last year and must say that though my previous DSLR did give a tad bit of better result, the 6+ & 7+ really gives it a competitive result.
So now I use my 7+ as a point and shoot camera shooting RAW in either Camera+ or Procam, and then do all post-processing on my MacBook, or if it’s for a quick on-the-go update/post/etc I use Pixelmator for iOS.
A simple way to do this is to get a USB card read and pop the card out of the camera and import it into Apple Photos. It is the simplest way.
Do not delete photos from the card; EVER!
Only format the card in your camera.
Do not do not do not erase or reuse the card until you have your photos backed up.
Keep three copies of all your images. Working copy, onsite-backup, and offsite backup.
I do not think that iCloud Photo Library as a backup it is a sync and sharing service.
NOTE: I do this every day with three or four cameras. It works!
NOTE2. There were several comments about just using your iPhone as your camera. That really can work. I am shooting with an iPhone X and it can be amazing. But there are limits with the small sensors and the fixed focal length lens. I have a couple of the moment.co lenses to extend the system and they help but add to carry needs.
NOTE3. Finding a good point and shoot camera is a bit hard these days. Look carefully before you buy one. dpreview.com is one place to look.