DSLR with a Macro or a Nikon S4 ($200) will take great macros. I use an old school Nikon 995 P&S for most of the close ups on my site
www.japaneseSword.com, my D50 with Macro lens is just too cumbersome for what i need for the site.
BUT most important tool for Macro is a tripod. If you already have a P&S with Macro, try it with a tripod to see if it will do what you need.