Deetee,
Macro shooting is extremely challenging, because we need to take care of so many things. Despite having a good macro gear I seldom manage to get a good macro, I probably get one good macro shot a year.
Macro is shooting is not just about magnification, you also have to get your composition spot on. Composition is the most difficult and most important aspect of macro image.
This is one of my rare good macro shot. A stalk of rice.
It is easier to shoot macro in P&S than dSLR, but if you can do it with dSLR, nothing like it. These are the challenges in macro shooting.
1) Composition: You need a really creative mind to consistently create good compositions. I often throw away every shot after a 2-3 hour session.
2) DOF: The macro lenses offer DOF in millimeters, which means you have to shoot with really narrow aperture, basically F-stop in double digits to get even an inch worth of DOF.
3) Speed: High F-stop means you have to compensate using low shutter speed. That means hand-holding is out of question, you have to use tripod. Even clicking can induce a shake, even the mirror slap can induce a shake. So you have to lock the mirror before clicking, and also use remote release to avoid touching the camera.
4) Conditions: Shooting that lovely flower in the garden? Pick a time when there is no wind, say early morning. If there is wind, the flower will keep moving in and out of your DOF and even the entire frame. Since you are forced to shoot low-speed, you can't afford even the slightest shake.
After all the precautions you have taken with the conditions and technique, you will still find almost all your shots very ordinary if you can't get the composition right. That is why photomacrography is one of the most frustrating experience. But it can also be very rewarding if you can get it right. There is a guy in PAAI named Image (Ram) who gets it right most of the time. A macro done right, can blow your mind away.