There are a few wireless cameras around and even a wireless SD memory card.
But I don't think they will be what you are looking for.
You might look at special software as a solution.
It works with many DSLR cameras and about a dozen Canon PowerShot cameras.
http://www.breezesys.com/
For PowerShot cameras look at the program called PSRemote.
...
Regarding camera qualifications - You will not find any digital camera under $300 that does well in low light unless you use flash or floodlights.
..
I'm looking for a Point-and-Shoot camera with an "automatic file transfer" ability. When I click on the shutter button of the camera, I want the picture file to be automatically transferred to the computer's hard drive. (No intermediate step, just press shutter button and file transfers.)
I prefer the transfer done via a wired USB connection, but wireless is also acceptable. I'll also need the ability to customize the folder location on the computer the picture would be sent to.
If you're familiar with the Canon EOS Utility software for DSLR cameras, it does the same thing. But I'm trying to find a Point-and-Shoot equivalent. Thanks.
Budget: Under $300
Special features request: Long battery life.
Size: Pocket-sized
Megapixels: Around 7, could be lower or higher.
Optical Zoom: Standard
General Use of Camera: Taking close-up pictures.
Shooting a lot of indoor photos or low light photos: Possibly.
Any particular brands/models you like or hate: No.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic