If you are looking for a good camera, one that is coming down in price right now is the CanonT1i. (In Canada anyways It is $600). It takes full HD video, has a built in flash. Several pre ops for taking photos. There are many lense options for this camera.
One very popular lense is the 100mm f2.8 usm which can be found for $600-$900 new, or $300-400 used.
Professional macro lenses are rather expensive, but you can cheat a little bit with the screw on 10x or so macro extensions which work like a magnifying lense on stock or zoom lenses, may be a temporary cheap option for a macro lense.
You could also go with the older Canon dslr camera in the 10 - 12mp range, but I don't believe they have the full HD option for video.