It sounds like your main interest is video.
A camcorder does this best.
Our camcorders forum is here:
http://forums.cnet.com/camcorders-forum/?tag=TOCleftColumn.0;blankArea.2
Almost all compact digital cameras use a 1/2.3 sensor.
They can do low light but not well.
Some camcorders do better in low light.
Almost all use SD storage cards.
With that size sensor 16 megapixel is not a good choice as 16 megapixel sensors have too much noise in low light.
10 or 12 megapixels is optimal.
Auto flash and red eye reduction is standard on all.
All store picture and video files on a memory card which can be read by a card reader.
Such files can be transferred to a computer.
...
Boy are there lots of choices out there.
I have resisted digital now about as long as I can, but the time has come . . .
There are a lot of users out there, and I need your help. Basically I am starting out with major requirements:
Able to take HD videos--1080 at least.
Whatever is needed to use inside and with low light.
Ability to transfer or connect via USB port, pics and videos to television.
Some type of storage capability to transfer to computer and/or social network (does not have to be WiFi).
Auto-flash, w/red-eye reduction.
Image resolution of 16 megapixels or better.
A 1 2/3 inch image sensor.
Optical zoom of 12 or greater.
Is there ANYTHING close to these guidelines around 400 or less?
Any help would truly be appreciated!!

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic