I'm under the camp that compacts are sometimes best for macro. This photo was taken with a Fuji FinePix E510 on super-macro mode. Fuji's seem to always be good with their macro modes.
I must add this was before I bothered about photography so I realise how poor it is lol.