A practical option is to choose a camera that supports Eye‑Fi SD cards. In that setup, the card handles the wireless upload, so the camera itself doesn’t need a complex built-in transfer workflow.

So rather than looking for a specific compact camera with fully automatic PC transfer, look for one with SD card compatibility and confirmed Eye‑Fi support. Then the process can be much closer to: shoot a photo, and the JPEG uploads automatically to your computer or network destination.

Whether it works exactly the way you want depends on the Eye‑Fi card/software setup and the camera supporting those cards properly.