Great Camera

What is a really great camera?

I need a new camera this summer but I cant spend too much.
I need something that has a good zoom and can capture action. I also need something that works well outdoors/indoors and in low light and can make decently timed videos with sound.
What do you recommend?

I would recommend the Canon PowerShot SX100 IS which is averagely priced at $240.00 (as low as $197.00)

http://www.imaging-resource.com/PRODS/SX100IS/SX100ISA.HTM

8.0-megapixel CCD, delivering image resolutions as large as 3,264 x 2,448 pixels
10x zoom lens (equivalent to a 36-360mm lens on a 35mm camera)
2.5-inch color LCD display
Automatic, Program, Aperture Priority, Shutter Priority, and Manual exposure modes
Built-in flash with five modes plus an intensity adjustment
Portrait, Landscape, Night Snapshot, Kids&Pets, Night Scene, Indoor, Foliage, Snow, Beach, Fireworks, and Aquarium scene modes
Optical image stabilization prevents blur from camera shake
Movie recording mode, with sound and ability to adjust exposure
Auto or High-Auto ISO setting or 80, 100, 200, 400, 800, and 1,600, ISO equivalents
Shutter speeds from 1/2,500 to fifteen seconds, depending on the aperture and zoom position

Emergency AIRPLANE LANDING ON ROAD! GREAT CAMERA ANGLE

Check out these related Great Camera products from Amazon: