As far as what macro I would like to do, I tend to be drawn to taking photos of flowers, plants, and weeds, with the occasional bug that may cross my path.
As for my competency with a camera, a week ago I was using a point-and-shoot (Canon PowerShot SX 700 HS). I would have told you I felt quite confident in my ability to use the settings (shutter, aperture, ISO) to get the photo I wanted. However, my husband wanted to be a total love and bought me a Canon 70D about 3 days ago. Now, I would say I am very not confident in all my settings or my ability to get the shot I want. Yes, I know there is a learning curve. However, the biggest thing I have noticed is that I can't seem to take the photos I am drawn to with the new DSLR (flowers, plants, weeds). This is why I'm hoping to pick up on of the mentioned pieces of equipment. I can't afford to pick up a dedicated macro lens at this point, but I miss my flowers.
Thank you to everyone for their wonderful information and help. I think I am leaning towards a set of extension tubes at this point.