There's a big difference between a $200 and $2,000 camera, yes -- but I have a point-and-shoot that cost me about $400 around three years ago that I absolutely love. It's the Canon Power Shot G15 - I got it for a good price after they released the G16 . . . I think they are finally on to another model now. See if you can find a G16 now that they're selling the new model.
Check B&H Photo Video - our family has bought all our cameras there for the past probably 15 years and have always been pleased with their service and prices.
Mine doesn't have WiFi capability, but I would bet the newer ones do. It goes have a mini USB port but I've never used it - I have a backup battery so I always keep the second one charged, and I upload my photos to my computer by putting the SD card in the slot.
Here's a review on the G16:
http://www.digitalcamerareview.com/camerareview/canon-powershot-g16-review-slight-upgrades-still-a-great-camera/
and some select quotes:
Ergonomics and Controls
The Canon G16 could easily be the poster child for well-designed P&S cameras. Ergonomically, this camera was obviously designed by photographers, for photographers.
Performance
This where the rubber meets the road and the G16 rises to the
challenge nicely. Basically, I judge cameras on one simple
criterion–does the camera do exactly what I want it to do or does it
get in my way? The Canon G16 does exactly what you tell it to do and
it does it with efficiency and alacrity.
I found the G16 to be remarkably fast to find and lock focus on my
subjects – as fast (or faster) than any P&S digicam that I have ever
used.
It appears that all new premium digital cameras must feature Wi-Fi
connectivity and the G16 is the first G model to provide this “hot
button” feature. Although it’s not the most comprehensive Wi-Fi
configuration available, the G16 allows users to either connect to
their smartphone or tablet via a free app or to their desktop or
laptop via a home Wi-Fi network. Personally, I am much more impressed
with the new sensor and new processor than I am with the addition of
Wi-Fi. I can wait until I get home to download and share my images.
Edit to add: B&H has a couple of used, reconditioned G15s for sale for $279 and $299. (the same as mine - but remember this version is wifi-LESS).
The site says that a possible successor to the discontinued G16 is the Canon PowerShot G7 X Mark II -- but it retails for $679!!