Depending on your budget, there are some nice options out there. If I were doing mostly macro photo, I'd look at the Canon EOS-M options. Canon has an awesome-looking macro for it, that even has a light-up ring at the end.

Some of the point-and-shoots are pretty nice, too. I have owned quite a few, but they never seemed to last long. I literally had one a week before my dog (naughty coonhound) saw a rabbit, yanked the leash, and sent it flying. It still worked, but looked like a salvage yard scrap.