What is a great camera for digital photography?

I would love to get the Canon Digital Rebel, but it’s out of my price range.

I need something that has great focus, mininum noise, great macro, and under $400.
I’ve been doing digital photography for over a year now, and my HP camera is slowly losing it’s quality.

Cameras I’ve thought about:
Canon PowerShot S60
Olympus SP-510 UZ

thanks in advance!