don't go with the fuji s9000, or the sony. Get a real DSLR. The fuji's "super ccd" is not really that super, and the "SLR" sony has a HORRIBLY small CCD.
And if you want to do macro photography, you can look into getting an extension tube. Much cheaper than a macro lense, and great to start off with. Maybe $100 canadian, compared to a good $1000 macro capable lense. Remember when buying your camera, too. It's only as good as the lense. For every $500 you spend on your camera, spend $250 on your lense. May sound expensive, but remember. That lense will still be worth $500 five years from now, while your camera won't
And yeah, I agree: go solid state rather than a microdrive. Microdrives are slow and have huge fail ratios.
here's a good site.
http://www.dpreview.com