I've used inexpensive gooseneck halogen desk lamps, with deflectors and bounce cards. Sort of a mini studio set-up on my dining room table. For backdrop, tri-fold cardboard presentation boards (at office supply stores) come in black or white. I've also used sheer white cloth behind with a strong light source behind to get a white background. All very inexpensive but takes practice to get the lighting right and control the shadows.
Exposures were usually up to 30 seconds and I often had to remind my 7 y.o. son not to run through the room during the exposure. There are some examples of macro shots using this setup in my personal gallery. Good luck!