keep a close eye on the Sony section and B&S if you want a cheap A100 body (700 or so)
The E510 is a nice cam, but from my testing i wasn't too happy about the image quality. At times it seemed over-saturated. Also, it has a 2x crop, so it's hard to get wide-angle shots. I didn't like the feel of the camera; it didn't fit my hand right, and I didn't find the controls intuitive. Battery life is ok, but it takes forever to charge the batt!! Also, the E510 supports no battery grip.
The "Live View" is an interesting addition, but can really slow down the whole picture taking process; once you're in live view mode, you can't "half-depress" the shutter button to autofocus. You need to press it all the way, or manually focus and use the focus lock button. But it still needs to drop the mirror before it can take the pic, adding almost a second of shutter lag. I find it somewhat useless.
Focusing in low light tends to hunt a lot.
So, biased as you obviously are, I'm talking from my own experiences. If you re-learned how to shoot just to compensate for the camera's shortcomings, good for you.
Thanks bros for all your comments! I've decided on getting the A100 because of its price.
By the way, I'm contemplating buying the Tamron 90mm Macro lens but I understand that there are 2 versions of it, the MF version and the AF version. Is there any difference if I were to use it to take macro shots of still objects and maybe food? Thanks!