I love my DSLR, but I think you might be better off with a really good point and shoot.
The main advantages of DSLRs over P&S are 1. lots of lens choices 2. lots of external flashes 3. easy manual controls 4. smaller depth of field (blurrier backgrounds)
The main advantages of P&S over DSLRs are 1. lots of versatility for relatively cheap 2. easier to use 3. more portable 4. larger depth of field (easier to get the complete frog in focus)
If you are not planning on lots of different lenses/flashes, and plan on using auto mode, then the only advantage of DSLRs is small depth of field (which can be very difficult to use effectively)
DSLRs will definitely give better pictures, but will take a lot longer to learn, and will probably cost more $ also.
If you go with a DSLR, I would recommend a Canon or Nikon because they are more common and therefore, there are more used lenses available. There are also more lens choices.
And to actually answer your question, I use a Canon 60D and 100mm f/2.8 macro lens.