I don't find it that bad. On my Sony camera, you can click the "transfer" button on the camera and then put the camera in NFC range of your phone. Then the Sony app starts, shows you a dialog to choose the resolution you want to download (useless IMO, I just want the original resolution of course) and then the two devices just transfer it through WiFi direct without any problem.
That's my experience, I'm sure it doesn't work well for everyone and it's still too cumbersome to do it all the time. I only use that feature when I really want to send to someone a photo I just took.
Yeah I have a Sony as well, and the amount of clicking is pretty darn annoying for my use case - I document far-right rallies on Twitter, which means I gotta be fast in transferring pictures from my camera to my phone.
Ideally, I'd have the camera be constantly connected to my phone's hotspot so I can immediately browse the photos and upload them - partially because selecting photos on the camera to be transferred is a pain, and partially because while Sony does allow connecting to an AP and transfer from a laptop, it is an exclusively foreground application, meaning the transfer interrupts when I have to spontaneously make a new photo / video.
That's my experience, I'm sure it doesn't work well for everyone and it's still too cumbersome to do it all the time. I only use that feature when I really want to send to someone a photo I just took.