New digital camera!?

Looking to upgrade from a 4.0 MP Olympus...

Looking for decent:
macro pics (important)
low light pics
6MP or higher
video function (I know camera videos tend to suck)
under $400 (less is better if I can get away with it =D )

Any suggestions for me?

I have a Sony Cybershot DSC N-1. 8.1 MP, 3x optical and 2x digital zoom, does macro, low light, and video. It's nice because it has a touchscreen instead of the little button/knob controller, so #1, it's easier to navigate, and #2, the screen is bigger than most cameras. I get about 300 pics on a fully charged battery. It's also nice because it uses memory sticks, so you can store loads of images if you need to. I think I can hold about 200 of the highest resolution picks on my 2 GB stick. The new DSC N-2 is the same camera w/ 10.1 MP, retails for $400 on bestbuy.com, I'd bet you can find it for cheaper. I haven't checked for the 8.1 MP model cost, but I'm sure they're out there. The only disadvantage is there is no viewfinder so you have to use the screen to frame your shot.

Kodak Z650 or Z612. I've been checking them out myself. The Z650 is less expensive. The best price I've found so far was $198.00, plus a little bit for shipping and sales tax, online at Wal-Mart's website. (Stupidly, it's $50 more, before sales tax, at the store.)

Casio S770. Beautiful camera.

http://www.techtoysforless.com/casio-dig...
http://www.exilim.com

canon sd600
I have one
good and easy
go to shopzilla.com for prices

I just love my camera. It takes grear shots; well that's because of the great photographer behind the camera. Sony CyberShot DSC-H2. Has 6 megapxels, 12X optical zoom, image stabilizer, great on batteries, comes with batteries and battery charger. I paid $341 at Best Buy but can be gotten cheaper on internet via camera stores at around $300.