It really depends on what you want to do with the camera. I know that sounds like a cop-out, but it isn't. The camera you are looking at is a good general-purpose camera. If you are serious about making high quality images and doing macro work, you are going to quickly outgrow it. The Macro lens you are referring to, I think, is a screw-on Macro adapter that goes on the front of the lens.
For anyone that is really serious about photography and macro in particular, I would recommend getting a DSLR (or SLR if you want to use film)and a dedicated Macro lens. The reason is the ability to interchange lenses and for certain other features you can only get on a single lens reflex camera. My digital body is a Canon 10D. It is a 6.3 megapixel camera. My main film body is a Canon EOS3. They use the same lenses, a major advantage since some of my lenses cost as much as or more than the camera body. Getting into a DSLR is an expensive proposition, but worth every penny in the quality you can get from your images. When you are shooting digital, the post-processing software you use is also important. I use Photoshop CS, but Photoshop Elements comes with the camera (at least with Canon cameras) and will get the job done.
For macro work, a good, sturdy tripod and remote shutter release is a must.
One of the features that my 10D has is the ability to lock the mirror up before the shot. This is a big plus, because the mirror induces some vibration when it flops up before the shutter fires. Vibration is magnified right along with the image, resulting in a blurred picture if you can't eliminate it. This feature allows you to eliminate the vibrations. This is absolutely necessary when I'm shooting under very high magnifications such as macro work or when I'm taking pictures at 1,600x through a microscope.
-----
We do not inherit the Earth from our ancestors; we borrow it from our children. Ralph Waldo Emerson
