Bob understands - I recently bought a Canon G9 partially for it's close-up abilities, but for a lot of other reasons too. I use numerous cameras from day to day but you will probably be happiest with a bridge camera, like Bob's or a point 'n shoot llike some of the high end Canons that allow you to control the aperture for depth of field. A DSLR probably won't give you the results you want unless you have a good macro lens, like the Tamron 90mm f2.8. You will get greater depth of field easier with the aforementioned fixed lens camera types. You can also add close-up lenses to those to get as close as you want.
Look at Canon G9, G10, S5is, SX10is, etc. - one of the desireable features on these is that they will take an external flash!
If you understand photography this will make sense, if not you should learn the basics to make informed decisions.