I own that camera, and really enjoy it.
It will take some good photos, and the Super Macro is a really nice feature. It will do things with the built in lens, that people with SLR's will have to spend $$$ to recreate (albeit better results are possible with that $$$).
The digital focus can be a pain to nail in Macro shooting, but you will get used to it eventually. Just take lots of shots
I generally shoot in Av or M.